Articles in this section

See more

MySQL error in Plesk for Linux: Column count of mysql.user is wrong. Please use mysql_upgrade to fix this error

Avatar
Kuzma Ivanov
Updated
Follow
Plesk for Linux kb: technical

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

    In the mentioned above error logfile, the following error message appears:

    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

  • Plesk backup finishes with warnings:

    PLESK_INFO: Warning: mysql "db_example"
    Not all the data was backed up into /var/lib/psa/dumps/domains/example.com/databases/db_example_1 successfully. Total space: 200.00 GB; Available space: 150.00 GB; Mounted on: /. mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'db_example'': Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100134, now running 100313. Please use mysql_upgrade to fix this error (1558)

  • Routines (stored procedures and functions) are not displayed in phpMyAdmin.

Cause

The mysql.user table has an incorrect schema.

Resolution

  1. Connect to the server via SSH.

  2. For security reasons, create a backup of the /var/lib/mysql directory:

    Note: This step is not required if you have a full server backup/snapshot to restore.

    2.1. Stop the MySQL server (The command depends on OS and installed MySQL server):

    # service mysqld stop

    # service mysql stop

    # service mariadb stop

    2.2. Copy the directory (Make sure that there is enough disk space on the server using the command df -h):

    # cp -rp /var/lib/mysql/ /root/

    2.3. Start the MySQL server:

    # service mysqld start

    # service mysql start

    # service mariadb start

  3. Upgrade MySQL databases:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` /usr/bin/mysql_upgrade -uadmin --force

Comments

2 comments

Sort by Date Votes
  • Avatar
    David Rieß

    After entering 2 commands above, i encountered following error:

    mysql_upgrade: [ERROR] unknown variable 'forceMYSQL_PWD=$AES-128 .............

    -------------------------------------------------------------------------------------------------------------------------------
    I still have the problem:

    Die Installation von WordPress unter https://xxx.yz/wordpress ist fehlgeschlagen. Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 50633, now running 50721. Please use mysql_upgrade to fix this error.
    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @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.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles