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

LoadFactor

• February 02, 2023 08:59

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 Jurassic Moderator

  • February 02, 2023 15:53

  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.

  0
• 

  LoadFactor

  • February 02, 2023 16:00

  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?

  0

Please sign in to leave a comment.