Tried that. I get the following: Oliver:~/Research/Right Whale chris$ mysql mysql -u root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.1.12-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> flush privileges; Query OK, 0 rows affected (0.11 sec) mysql> Bye Oliver:~/Research/Right Whale chris$ mysql mysql -p Enter password: ERROR 1045 (28000): Access denied for user 'chris'@'localhost' (using password: YES) On 7/14/05, Danny Stolle <[EMAIL PROTECTED]> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]