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

[Jeff Weeks]

I ran a command which was part of the installation process for some php 
accounting software.

update user set  host='%' where host='localhost' and user='root';

Figured it just let root log in from anywhere.  Dunno if that is what 
caused the problem or not.  But now root can't access anything in mysql 
anymore.  When I do \s it shows the user as '[EMAIL PROTECTED]'.  But when 
I try to look at tables in mysql it thinks the user is only 
'@localhost'.  The error I get is:

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

Anyone know wassup....?

Thanks.

Jeff



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]