root, mysql, mariadb.sys gone from mysql.user
Hi,
After mysql have small error unable to login with root user all cpanel user access denied in log err mysql. I check from phpmyadmin these user not exist in table user mariadb.sys, root and mysql. I am try recreate/insert command but not work since mysql running with skip-grant-tables.
I was hoping someone could help with recovering the root, mysql and mariadb.sys users in table mysql.user
-
Can you try to fix this by using the automated tool in WHM >> MySQL Root Password? This will attempt a reset of the MySQL root user password on the system, and may be enough to get that resolved for you. If, it is not resolved try the below steps too. - Stop the MySQL server.
- Start the MySQL server with the --skip-grant-tables option.
- Log into MySQL without a password.
- Update the root password using SQL commands.
- Restart the MySQL server normally
0 -
Can you try to fix this by using the automated tool in WHM >> MySQL Root Password? This will attempt a reset of the MySQL root user password on the system, and may be enough to get that resolved for you. If, it is not resolved try the below steps too.
- Stop the MySQL server.
- Start the MySQL server with the --skip-grant-tables option.
- Log into MySQL without a password.
- Update the root password using SQL commands.
- Restart the MySQL server normally
Hello sir, The server already with skip grant tables. I have do your mentioned, but user root, mysql is not in the list table mysql.user. Change password from whm interface work well but i don't know why root user still unable to login (Access denied for user).0 -
I check table mysql.db also not have any user or no data. How to recreate all cpanel database user to database? 0
Please sign in to leave a comment.
Comments
4 comments