Restore mysql

From Hashmysql

I've deleted the root user, and there's no other user with all privileges!

• Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).
• Insert a record for the root user into the mysql.user table. The structure of the table changes with the version, so use the appropriate one:
  • For 5.1 and 5.2:
  • INSERT INTO `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
  • For 5.0:
  • INSERT INTO `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
  • For 4.1:
  • INSERT INTO `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
• Stop mysqld and restart it as normal. You should now be able to login as root with a blank password.

I've dropped the entire mysql database, which holds all the privileges I need to login.

• Stop mysqld and restart it with the --skip-grant-tables --user=root options (Windows users omit the --user=root portion).
• Recreate the mysql database. If you have a backup, use that. Otherwise, issue CREATE DATABASE mysql; and then run the SQL file below that is appropriate for your version:
  • MySQL 5.2
  • MySQL 5.1
  • MySQL 5.0
  • MySQL 4.1
• Stop mysqld and restart it as normal. You should now be able to login as root with a blank password.