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

Follow

Comments

2 comments

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

Please sign in to leave a comment.

Have more questions? Submit a request