Sorry. While I am able to log in, I get the following: | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '*446CB892D3DFFDDC86BDDF26E4EB43158356DF64' WITH GRANT OPTION |
after a restart, I get | GRANT ALL PRIVILEGES ON *.* TO 'chris'@'localhost' IDENTIFIED BY PASSWORD '3446cb892d3dffdd' WITH GRANT OPTION | Does this mean the password has somehow changed? C. On 7/15/05, Michael Stassen <[EMAIL PROTECTED]> wrote: > Chris Fonnesbeck wrote: > > Here is the startup script: > <standard script snipped> > > The grant command was: > > > > grant all on *.* to [EMAIL PROTECTED] identified by 'my_password'; > > > > Thanks for the help, > > C. > > Chris, > > You only answered one of my questions. I'm hoping to narrow the problem by > determining whether the problem is on the server or in the client. > Unfortunately, you haven't given enough information to clear that up. > > I'll try again. > > 1) Right after you've issued the GRANT, while you can log in as chris, what > does > > SHOW GRANTS FOR 'chris'@'localhost' > > give you? > > 2) When you say "restart the server", what, exactly, do you mean? Are you > restarting mysqld, or the whole machine? > > 3) After restarting, when you cannot log in as chris, what does > > SHOW GRANTS FOR 'chris'@'localhost' > > give you then? > > Michael > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
