Issue I cant add or remove any database

[Kaz]

Hello.

I cant remove or add any database.

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

How can i fix this?

P.D. Im a total noob please be kind.

Thank you very much in advance.

 

[IgorG]

Im a total noob please be kind.

If you can't apply solution from this KB article - Unable to connect local MySQL instance (bind to port 3306) to Plesk: The test connection to the database server has failed because the supplied account does not possess administrative privileges please ask Plesk Support Team assistance.

 

[Kaz]

Hello thank you for the suggested solution. I already tried to reintall Mysql component and i keep getting the error. Also my Administrator account have granted all privileges.

Im trying this solution:
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user - Blog Hostripples

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.


But i get this error:

mysql> GRANT ALL ON *.* to admin@'%';

ERROR 1133 (42000): Can't find any matching row in the user table


What can i do?

Thank you very much in advance

 

[IgorG]

Because ADMIN and admin is not the same.