Column count of mysql.user is wrong.

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.

Errors similar to one of the following will also appear in the MySQL log.

[Warning] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 51, found 45. The table is probably corrupted

[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade

Description 

This generally occurs when the mysql tables need to be updated for the running mysqld version.

Workaround

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Run the commands for your MySQL server version.
   • MySQL 5.x or MariaDB

     mysql_upgrade

   • MySQL 8.x

     sudo -i su -l mysql -s/bin/bash

     mysqld --upgrade=FORCE &

     exit

     /scripts/restartsrv_mysql --stop

     /scripts/restartsrv_mysql --start