Article ID: 127423, created on Nov 14, 2015, last review on Aug 22, 2016

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows


  • Unable to add new database user in Plesk or create database under Domains > > 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.


MySQL system database was not properly upgraded.


  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 [KB116050]How to reset the MySQL administrator's password).

Search Words

Error: Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'


Unknown column 'plugin' in 'mysql.user'

Unable to create database user

unable to create database

connection to database failed plugin in my sql.user.

742559b1631652fadd74764ae8be475e 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 e335d9adf7edffca6a8af8039031a4c7 8b661cab116c79dbe6c4ac5bbdf1c8cb 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF