supplied account does not possess administrative privileges

[www.ServerTechSupport.com]

I recently upgraded the Plesk to 11.5.30. Now I am not able to create new MySQL databases. I am getting below error.

Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)

MySQL admin details are correct in plesk database, also the admin has full privileges. I am manually able to create databases, users from mysql prompt. It's just the plesk interface that's giving error. I think it's a bug. Anybody got any suggestions or workaround ?

C:\Program Files (x86)\Parallels\Plesk\MySQL\bin>mysql -u admin -p***************  mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 68
Server version: 5.1.68-community MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from user where user='admin'\G
*************************** 1. row ***************************
                  Host: localhost
                  User: admin
              Password: *F761B426F971829B516319F4780B69E9954475C4
           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
      Create_view_priv: Y
        Show_view_priv: Y
   Create_routine_priv: Y
    Alter_routine_priv: Y
      Create_user_priv: Y
            Event_priv: Y
          Trigger_priv: Y
Create_tablespace_priv: Y
              ssl_type:
            ssl_cipher:
           x509_issuer:
          x509_subject:
         max_questions: 0
           max_updates: 0
       max_connections: 0
  max_user_connections: 0
                plugin:
 authentication_string: NULL
1 row in set (0.00 sec)

 

[IgorG]

Try this solution

1. Edit my.ini file from MySQL database (Remember, you have a MySQL for Plesk and a MySQL for your hosting accounts. The folder should be something like \Parallels\Plesk\MySQL\Data\my.ini) and add the following lines:

[mysqld]
skip-grant-tables

2. Restart Plesk SQL Server service.

3. Open CMD, go to Bin MySQL folder, something like Paralles\Plesk\MySQL\bin, and type:

mysql --defaults-file="C:\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data\\My.ini"

The path in the --defaults-file is the path where is located the my.ini file you edit on step 1. If you just type mysql without the --defaults-file this procedure may not work.

4. Then:

update mysql.user set password = '' where user = 'admin';

5. Try logging in to Plesk now.

6. If it works Ok, don't forget to erase lines added on step 1 to My.ini and restart Plesk SQL Server service.

 

[www.ServerTechSupport.com]

Thank you Igor, but the issue is not with login into Plesk. It's when I try to create a new MySQL database or a mysql user for a database.

 

[InderS]

Have you tried submitting password in tools an settings >> database servers >> mysql server >> settings.

 

[sonics]

Hello all

we have since that morning the same. what can we do about it. i just wanted to change a db users password and now mysql via command line or also
another windows mysql admin tool is working. only via plesk we can not connect to db's.

please help.

 

[Kaz]

Im having this error aswell how can i fix it?

ERROR: CONNECTION TO THE DATABASE SERVER HAS FAILED BECAUSE THE SUPPLIED ACCOUNT DOES NOT POSSESS ADMINISTRATIVE PRIVILEGES:
ACCESS DENIED FOR USER ‘ADMIN’@’LOCALHOST’ TO DATABASE