Error adding remote database server

[KarelB]

PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit

PROBLEM DESCRIPTION
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server

STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server

ACTUAL RESULT
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges:
Access denied for user 'admin'@'%' to database 'd536cedf97037e'

EXPECTED RESULT
A working database connection.

ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:

140509 16:54:51 28 Connect [email protected] as anonymous on
28 Query SELECT VERSION()
28 Query create database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Query create database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Query insert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 Query FLUSH PRIVILEGES
28 Query GRANT ALL ON `BUG115166_1374110215536CEC3816DD2`.* to 'bug115166_17546'
28 Query DELETE FROM mysql.user WHERE User='bug115166_17546'
28 Query FLUSH PRIVILEGES
28 Query drop database if exists `bug115166_1374110215536cec3816dd2`
28 Query drop database if exists `bug115166_1374110215536cec3816dd2`
28 Query drop database if exists `BUG115166_1374110215536CEC3816DD2`
28 Query drop database if exists `BUG115166_1374110215536CEC3816DD2`
28 Query show databases like 'd536cec3816d48'
28 Query create database `d536cec3816d48` /*!40101 default charset=utf8 */
28 Query select * from mysql.user where User = 'u536cec381da1c' limit 1
28 Query insert into mysql.user (Host, User, Password) values ('%', 'u536cec381da1c', password('Ja6p3O!9sE'))
28 Query flush privileges
28 Query grant all on `d536cec3816d48`.* to 'u536cec381da1c'
28 Query drop database if exists `d536cec3816d48`
28 Query drop database if exists `d536cec3816d48`

If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.

 

[IgorG]

http://kb.parallels.com/en/1784

 

[KarelB]

Thanks, running this query fixed it:

update user set Grant_priv = 'Y' where user='admin';