Re: mysql root password problem

[Neil Curri]

Robert Goff wrote:
> ....But my speculation is that you might need to manually
> remove all records for the root user from the user table, then re-issue the
> grant command.  You're using the grant command, not inserting into the user
> table, right?  The grant command is less susceptible to typos causing you to
> be locked out of the root account.

Nope, I hadn't been using GRANT, I was modifying the mysql user table
directly, as root. I can't seem to get into the mysql database at all
now. I can start mysqld (as *system* root) with the -Sg option and log
into mysql, but now I can no longer modify the mysql database or issue
GRANT statements:

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Yikes, is it time to think about reinstalling?