They just stop working. The tables have the data in them. But they don't work.
So I do another GRANT....
And then they work fine, until the next day (not sure about the timing) when they have to be GRANT'ed all over again.
There doesn't seem to be any pattern to this. It happens more often on some dBs than others.
This is something that's be going on for a while now. It even caused me to get un-lazy and upgrade to 4.0.13 which didn't seem to help.
The dBs are all dumped every night.
I connect via DSL so I have a different IP, but I don't think that's an issue, here is the GRANT:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON DbNAME.* TO YYY@'%.t-dialin.net' <-- To catch the different IPs. IDENTIFIED BY 'XXXXXXX';
I thought it may be a MyODBC issue, but it also doesn't work in PERL/DBI until I do the GRANT again.
"flush priviledges" doesn't seem to have any effect. Only another run of the GRANT.
I should specify that it doesn't lose all GRANT info as everything connecting from localhost (but not "localhost") is fine, just my connections from outside the server.
Any ideas?
Thanks!!
Tosh
-- Tosh Cooey Twelve Hundred Group http://www.1200group.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
