I was playing around with the root mysql account on my server tonight and accidentally set the host permissions on the account to any, which made it root@% I assume.

Now what I've found in researching this problem is that when there is an account that isnt first defined as account@localhost and THEN account@% or @{any hostname} then attempting to login with 'account' from the system will be unsuccessful and result in this error:

DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'


So what I need to know is how I can make the root user root@localhost again so I can administer my system. I've tried using this method: MySQL :: MySQL 5.0 Reference Manual :: B.1.4.1 How to Reset the Root Password - to add user root@localhost with all privelages but that doesn't seem to work.

Thanks in advance.