User name stops working until flush privileges is run

Wed, 04 Apr 2007 07:32:45 -0700 

Hi,
I have a MySql database running on version 5.0.27 which every few days for no reason I can fathom stops letting me log in. 

    mysql -u username dbname -p
    Enter password:

    ERROR 1045 (28000): Access denied for user  
'username'@'localhost' (using password: YES)



When I log in as root and run 'FLUSH PRIVILEGES' everything starts  
working again. I've looked at the doc for 'FLUSH PRIVILEGES' but I  
still can't work out what's going. Does anyone have any idea what  
would make a previously working username stop working until FLUSH  
PRIVILEGES is called? I'm not doing any direct manipulation of the  
user table. Everything goes through 'create user', 'grant', 'set  
password', etc so it seems that 'flush privileges' should be redundant.


Thanks,

- Richard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]























					Reply via email to