• Mysql

Column count of mysql.user is wrong

By PrasadNaik

March 26, 2018

Was getting below error while trying to create mysql user in cpanel

Error from MySQL query :(XID 5yuvwf) The system received an error from the “MySQL” database “mysql”: 1805 (Column count of mysql.user is wrong. Expected 43, found 39. The table is probably corrupted):

The migration used a “mysqldump –all-databases” so it included the “mysql” database. Apparently the “mysql.proc” table changed between the versions. The fix on the new server is to run:

Below command fixed the issue