[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]

1. Stop the MySQL server.

2. Start the MySQL manually with the "--skip-grant-tables"

3. If you completely deleted the root user, run this command:

   GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';

4. Stop the MySQL server.

5. Restart the MySQL server normally

More help on resetting the root account can be found here.