KB #1784 - I get the "Access denied" error during managing databases or databases' users through Plesk CP.

SYMPTOMS

"Access denied" error occurs when I try to manage databases or databases' users on the local or remote MySQL server. Error message looks like:

Error: Connection to the database server has failed because the supplied account does not possess

administrative privileges: Access denied; you need the RELOAD privilege for this operation

The error may be related to any MySQL priviledge, but not only RELOAD one, that is listed in the example above.

CAUSE

This error means that MySQL administrator account that is used in Plesk does not have enough privileges to manage database/users in the MySQL server.

RESOLUTION

You should login into problem MySQL server with administrator account or restart MySQL in skip-grant-tables mode as described in the article 346. Then check that administrator account has right privileges, like on the example below:

    mysql> select * from user where user='admin' \G
    *************************** 1. row ***************************
             Host: localhost
             User: admin
             Password: 3d89770b0d299d60
             Select_priv: Y
             Insert_priv: Y
             Update_priv: Y
             Delete_priv: Y
             Create_priv: Y
             Drop_priv: Y
           Reload_priv: Y
   Shutdown_priv: Y
           Process_priv: Y
             File_priv: Y
             Grant_priv: Y
         References_priv: Y
             Index_priv: Y
             Alter_priv: Y
             Show_db_priv: Y
             Super_priv: Y
           Create_tmp_table_priv: Y
             Lock_tables_priv: Y
             Execute_priv: Y
         Repl_slave_priv: Y
           Repl_client_priv: Y
             ssl_type:
             ssl_cipher:
             x509_issuer:
           x509_subject:
           max_questions: 0
         max_updates: 0
     max_connections: 0
    1 row in set (0.00 sec)

Note: the MySQL administrator user name may differ from the one in the example above. If you use remote MySQL server without Plesk CP, most probably the MySQL administrator account name is 'root'.

If some privilege is not set, you may add them with "GRANT PRIVILEGE" query, see MySQL documentation for more information: http://dev.mysql.com/doc/refman/5.0/en/grant.html.

Parallels Virtualization and Automation Software

I get the "Access denied" error during managing databases or databases' users through Plesk CP.

SYMPTOMS

CAUSE

RESOLUTION

Please provide feedback on this article