This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

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