Issue plesk with percona

[Noam Harel]

Hi

I'm having a issue with connecting my percona cluster with plesk.
everytime i try to connect from plesk (tools&settings -> add database) to the percona cluster i get this error:
Error: The test connection to the database server has failed because the supplied account does not possess administrative privileges:

Access denied for user 'percona'@'%' to database 'd597b03c0af1a8'

notice, i have granted all privileges to the 'percona user' (GRANT ALL ON *.* TO 'percona'@'%' ); and from ssh everything is working good.

also from wordpress directly to the cluster everything is working well.

please your thoughts and advice.

Noam

 

[Bitpalast]

Have you tried your grant statement with the add-on "WITH GRANT OPTION" or "WITH ADMIN OPTION"?

 

[Noam Harel]

Have you tried your grant statement with the add-on "WITH GRANT OPTION" or "WITH ADMIN OPTION"?

thanks for your reply,
can you give me the exact syntax please?

 

[Bitpalast]

GRANT ALL ON *.* TO 'percona'@'%' WITH GRANT OPTION;

 

[Noam Harel]

GRANT ALL ON *.* TO 'percona'@'%' WITH GRANT OPTION;

Thanks!! query OK

 

[Noam Harel]

by the way, when i try WITH ADMIN OPTION i get an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADMIN OPTION' at line 1