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

[LoadFactor]

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.

 

[cPRex]

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]

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?