Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user

Hello,

Error code :

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

 

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.

Solution :

 

root@server01[~]#mysql 
mysql>use mysql
mysql>select * from user where user='admin' \G
*************************** 1. row ***************************
             Host: localhost
             User: admin
             Password: kjh2170b0d299d60
             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)
mysql>GRANT ALL ON *.* to admin@localhost;
mysql>GRANT ALL ON *.* to admin@'%';
mysql>update user SET Grant_priv='Y'  WHERE User = 'admin';

Quit the mysql shell and you are done.
 

Also read,


Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user, Hostripples Web Hosting

Vishwajit Kale

Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.