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:
Repairing of the Database did not solve 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 !!!!!
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
was also no solution for my problem.MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --force
[.....]
Running 'mysql_fix_privilege_tables'...
OK
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 !!!!!