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
Add new attachment
Only authorized users are allowed to upload new attachments.
«
This page (revision-6) was last changed on 24-May-2017 15:30 by Hyve Support