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_12.5.30_repair.log), fix and try again -
The following error message can be found 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.
-
Unable to create a database in Plesk 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.
# 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
-
-
Run mysql_upgrade:
# 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.