• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50167, now running 5

alli81

New Pleskian
Hi,
i'm trying to add a new user on a database in plesk but i receive this error:

Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50167, now running 50557. Please use mysql_upgrade to fix this error.

How is possible?
How i can do?

My mysql version is
mysql Ver 14.14 Distrib 5.5.57, for Linux (x86_64) using readline 5.1

i use it on centos 6
 
Hi alli81,

Please use mysql_upgrade to fix this error
Did you read this suggestion?

Pls. try for example the command ( logged in as user "root" over SSH ):
Code:
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
... and pls. report the output from your command line.
 
Back
Top