on 9/2/05 4:10 PM, Michael Stassen at Michael.Stassen@stripped wrote:
> So root@localhost 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
> root@localhost'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.
