Symptoms
When you try to create an account or change a password for MySQL, you receive this error:
Error from MySQL query: Cpanel::Exception::Database::Error/(XID r9urzw) The system received an error from the “MySQL” database “mysql”: 1805 (Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.
Description
This generally occurs when the 'mysql_upgrade' command needs to be run, we can confirm that is the issue by looking for errors similar to this in the MySQL error log:
[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Workaround
To correct this, run the following command via SSH as the root user:
mysql_upgrade