on 9/2/05 4:10 PM, Michael Stassen at [EMAIL PROTECTED] wrote: > So [EMAIL PROTECTED] is missing something (you can't GRANT a privilege you > don't have). In that case, I think you need to do as Gleb suggested. Shut > down mysqld, then start it with --skip-grant-tables and reissue > > GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'; > > then stop and start the server again.
I take it my uptime value is going back to zero :-) > Alternatively, you could try to do this witout stopping mysqld. UPDATE > [EMAIL PROTECTED]'s row in the mysql.user table to have the correct values, > then FLUSH PRIVILEGES (but I'm suspicious something like that is how this > started). I never fiddle direct like that, but there was that fix_privs_table script mysql provided I had to run at one time during an update. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
