[RESOLVED] PHPMyAdmin error

[naskar]

Hi there I got PHPMyAdmin to work and while I was configuring privileges I accidentally deleted the ROOT user..

When I tried to go the main PHPMyAdmin screen it keeps giving me an error saying

#1130 - Host 'localhost' is not allowed to connect to this MySQL server

How do I go about restoring the root user?

[bradgrafelman]

Stop the MySQL server.
Start the MySQL manually with the "--skip-grant-tables"
If you completely deleted the root user, run this command: GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';
Stop the MySQL server.
Restart the MySQL server normallyMore help on resetting the root account can be found here (http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html).