Skip to main content
We are currently experiencing a higher than average ticket volume and as such our responses may be delayed. Searching on our Help Center articles or going to our Community is also a great resource for answers.

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

Comments

4 comments

  • 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.
    • 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
  • 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.
    • 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
  • Naila
    I check table mysql.db also not have any user or no data. How to recreate all cpanel database user to database?
    0
  • cPRex Jurassic Moderator
    The best option in this case would be to restore the database from a backup.
    0

Please sign in to leave a comment.