Danny Stolle wrote:
Chris Fonnesbeck wrote:
I have mysql 4.1.12 installed on OSX 10.4, and have run into the
curious problem that mysql forgets my user password (but not my root
password) when I restart the server. When I attempt to log in, I get:
ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using
password: YES)
Yet, when I go in as root and re-grant permissions with the user
password, access is restored. When I reboot, I get the error again.
What could possibly be causing this?
Thanks,
Chris Fonnesbeck
Sorry again ... forgot the mailing group ...
"Did you 'flush privileges'?"
Danny Stolle
Netherlands
Danny,
First, FLUSH PRIVILEGES is not needed with GRANT. Second, if he were editing
the user table instead of using GRANT and failing to FLUSH PRIVILEGES, he
would get the opposite behavior -- the login would not work before the
restart, but would work after.
Chris,
One possibility is a startup script which is altering the user table. Another
possibility is some error in granting permissions or restarting the server, or
logging in. It is difficult to say without knowing more. Please show us
* the GRANT command you use to create 'chris'@'localhost' (but don't show us
the real password)
* the output of "SHOW GRANTS FOR 'chris'@'localhost'" when it is working
(before a restart).
* the method you use to restart the server
* the output of "SHOW GRANTS FOR 'chris'@'localhost'" when it isn't working
(after the restart).
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
