Applicable to:
- Plesk for Linux
Symptoms
-
Plesk upgrade fails with a similar to the below error message:
CONFIG_TEXT: ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /var/log/plesk/install/plesk_XX.X.XX_repair.log), fix and try again -
The following error message appears in the logfile
/var/log/plesk/install/plesk_XX.X.XX_installation.log, where XX.X.XX is an actual Plesk version:CONFIG_TEXT: ERROR 1558 (HY000) at line 67: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50538. Please use mysql_upgrade to fix this error.
-
It is not possible to create a database in Plesk or install WordPress with the error message below. In some cases, other actions may lead to the same error, e.g., WordPress installation, new PHP handler installation, password reset:
PLESK_INFO: Connection to the database server failed: Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50556. Please use mysql_upgrade to fix this error.
-
Unable to create a database user or database or reconnect a 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
Cause
The mysql.user table has an incorrect schema.
Resolution
-
Connect to a Plesk server via SSH.
-
Stop MySQL:
-
on CentOS/RHEL-based distributions:
# service mysqld stop
-
on Debian/Ubuntu-based distributions:
# service mysql stop
-
if MariaDB is installed:
# service mariadb stop
-
-
Create a backup of the "mysql" database:
Note: Make sure that there is enough disk space on the server using the command "df -h".
# cp -rp /var/lib/mysql/ /root/
-
Start MySQL:
-
on CentOS/RHEL-based distributions:
# service mysqld start
-
on Debian/Ubuntu-based distributions:
# service mysql start
-
if MariaDB is installed:
# service mariadb start
-
-
Upgrade MySQL databases:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin --force
Comments
2 comments
After entering 2 commands above, i encountered following error:
mysql_upgrade: [ERROR] unknown variable 'forceMYSQL_PWD=$AES-128 .............
-------------------------------------------------------------------------------------------------------------------------------
I still have the problem:
@David
Hello!
The error is caused by incorrect syntax in MySQL configuration. MySQL is unable to recognize the variable "forceMYSQL_PWD".
Also, please, note that variable "MYSQL_PWD" is considered as insecure.
Please sign in to leave a comment.