Lost MySQL Root User, Create Root User skip-grant-tables#

• Login via SSH
• Open /etc/my.cnf
• add the following under the mysqld group

skip-grant-tables

• Restart MySQL and now you can login as any user with full permissions
• Go to mysql database and add a root user with permissions manually, set all priv fields to Y

For MySQL 4

INSERT INTO user VALUES('localhost','root',PASSWORD('PASSWORD'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);

• Remove the skip-grant-tables
• Restart MySQL and now you can login with your root user

Back to MySQL