Unable to change DB User password: The request failed. (Error ID: rs5c6r)

LoadFactor

Well-Known Member
Jul 12, 2013
89
18
133
cPanel Access Level
Root Administrator
A customer got this when trying to change the password for a DB user. A look at the error log reveals:

Cpanel::Exception::Database::Error/(XID az9mxb) The system received an error from the “MySQL†database “mysqlâ€: 1146 (Table 'mysql.global_priv' doesn't exist)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.

Checked the database and in fact the table does not exist.

I have been trying to open a ticket but id.cpanel.net and accounts.cpanel.net are in a redirect loop, after removing cookies.
 
Last edited:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
16,538
2,608
363
cPanel Access Level
Root Administrator
Hey there! We're aware of the issues with the store and tickets and our team is working on that.

Unfortunately, the only way to resolve that would be to restore a backup of the MariaDB system tables. If you have your backups configured to also backup the system files, you can restore the database from a recent backup.
 

LoadFactor

Well-Known Member
Jul 12, 2013
89
18
133
cPanel Access Level
Root Administrator
The workaround is to remove and recreate the user instead of changing the password, which is odd in itself.

It appears that there's a step in the MariaDB upgrade process, 'mysql_fix_privilege_tables' that creates this table. We upgraded MariaDB some months ago so it's surprising that this just emerged now. I suspect the table hasn't existed for some time but I'll pull old backups to confirm.

Worst case, can I copy the schema from a server that has the table, and hope it populates?
 
  • Like
Reactions: cPRex