root, mysql, mariadb.sys gone from mysql.user

[Naila]

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

 

[techAMIGO]

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.

1. Stop the MySQL server.
2. Start the MySQL server with the --skip-grant-tables option.
3. Log into MySQL without a password.
4. Update the root password using SQL commands.
5. Restart the MySQL server normally

 

[Naila]

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.

1. Stop the MySQL server.
2. Start the MySQL server with the --skip-grant-tables option.
3. Log into MySQL without a password.
4. Update the root password using SQL commands.
5. 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).

 

[Naila]

I check table mysql.db also not have any user or no data. How to recreate all cpanel database user to database?

 

[cPRex]

The best option in this case would be to restore the database from a backup.

How do I restore a MySQL Database Table?

Question I need to restore only part of my database. How can I extract and restore a specific table from a full backup dump? Answer You can use sed to dump the individual tables you need to an S...

support.cpanel.net

If you don't have a backup available, there isn't an easy way to recreate those system tables, as those are installed by MySQL at the time of installation.