Unable to create database user: Unknown column plugin in mysql.user

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:15:20 UTC

Modified:

2017-02-02 15:53:40 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create database user: Unknown column plugin in mysql.user

Symptoms

  • Unable to add new database user in Plesk or create database under Domains > example.com > Databases :

    Error: Unknown column 'plugin' in 'mysql.user'
  • Unable to add MySQL database server or change password for user in Tools & Settings > Database Servers error above appears.

Cause

MySQL system database was not properly upgraded.

Resolution

  1. Check version of MySQL server:

    SELECT version();

    Try to execute the following query:

    SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user';

    The following values should be received:

    43 for MySQL 5.6
    42 for MySQL 5.5
    39 for MySQL 5.1
    37 for MySQL 5.0

    Compare these values with your version of MySQL.

  2. If the value does not match your version:

    Use mysql_upgrade command to check tables for incompatibilities with the current version of MySQL

    • For Plesk 12.5 on Windows:

      Open command prompt and execute:

      # cd "C:\\Program Files\\MySQL\\MySQL Server 5.6\\bin"
      # mysql_upgrade --upgrade-system-tables -uadmin -p -P3306
    • For Plesk 12.5 on Linux

      # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
  3. Try to create a new database or database users in Plesk.

Note: if password for MySQL server running on port 3306 is not available, use skip-grant-tables option (steps 1-3 from [KB213947045]How to reset the MySQL administrator's password ).

Have more questions? Submit a request
Please sign in to leave a comment.