- Plesk Onyx 17.5 for Linux
Unable to create db user or database, either as reconnect database server at Tools & Settings > Database servers > db_server > OK :
PLESK_ERROR: Column count of mysql.user is wrong. Expected 45, found 48. The table is probably corrupted
Unnecessary columns in
Compare the structure of
mysql.user table with the same one from the same clean environment and remove unnecessary columns.:
- Connect to the server using SSH.
- Run the command below to fix the issue.
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --force