Table of Contents
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,
