Resolved Column count of mysql.user is wrong. Expected 42, found 43.

[FireHost1]

I updated my host a few weeks ago to Onyx. Everything seems to be fine, unless i tried to add a new sql-User.
Column count of mysql.user is wrong. Expected 42, found 43. The table is probably corrupted

I searched and found a nearly similar problem (https://talk.plesk.com/threads/unab...plesk-but-mysql-is-reachable-from-ssh.342769/), but the solution there did not help:

mysql -V
mysql Ver 14.14 Distrib 5.5.55, for debian-linux-gnu (x86_64) using readline 6.2
plesk repair all -n
[....]
Repairing web server configuration .................................. [OK]
Checking the usage of PHP handlers .................................. [OK]
Repairing the mail server configuration ............................. [OK]
Checking the DNS configuration file ................................. [OK]
Restoring DNS server configuration .................................. [OK]
Checking MySQL database servers
Unable connect to localhost:3306: Column count of mysql.user is
wrong. Expected 42, found 43. The table is probably corrupted ..... [ERROR]
Repair databases on available servers ............................... [OK]
Repair database users on available servers .......................... [OK]

Repairing of the Database did not solve my problem:

plesk repair db -verbose
[....]
Run query: CHECK TABLE sys_users
Run query: CHECK TABLE Templates
Run query: CHECK TABLE TmplData
Run query: CHECK TABLE TraceFailedRequestsProviderAreas
Run query: CHECK TABLE TraceFailedRequestsProviders
Run query: CHECK TABLE TraceFailedRequestsRules
Run query: CHECK TABLE upgrade_history
Run query: CHECK TABLE web_users
Run query: CHECK TABLE webalizer_group_referrer
Run query: CHECK TABLE webalizer_hidden_referrer
Run query: CHECK TABLE WebApps
Run query: CHECK TABLE Webmails
Run query: CHECK TABLE WebServerSettings
Run query: CHECK TABLE WebServerSettingsParameters

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

Error messages: 0; Warnings: 0; Errors resolved: 0

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --force
[.....]
Running 'mysql_fix_privilege_tables'...
OK

was also no solution for my problem.
Somehere i read, that an update to 5.6 / 5.7 should be a solution, what do you think about that?
Or has anyone another idea? Thank you !!!!!

 

[WebHostingAce]

did you upgrade your MySQL as well?

have you tried,

#MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -u admin

 

[FireHost1]

No, it was 5.5 also before.
Yes i tried it, everything should be ok (see last part of my first post)...

 

[FireHost1]

An update to 5.6 solved my problem.