Issue Cannot add remote database

[sistemisti]

Server operating system version

CentOS Linux release 7.9.2009

Plesk version and microupdate number

18.0.57

Hi,
i'm trying to add to plesk an external mariadb database,
my plesk version is Plesk Obsidian 18.0.57 my OS is CentOS Linux release 7.9.2009
i insert the ip, username and password but i got this message

Database server was updated with error: The test connection to the database server has failed because the supplied account does not possess administrative privileges: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'root'@'xx.xx.xx.xx' to database 'd659d574468c62'.

the strange thing is that if i try with mysql client it's works

mysql -uroot -psupersecretpassword -hxx.xx.xx.xx
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 10.5.22-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

olso i can create,delete,use and query all databases
i create the user with the following command
create user 'root'@'%' IDENTIFIED BY 'supersecretpassword';
grant all privileges ON *.* to 'root'@'%';

someone can help me?

 

[sistemisti]

the problem is solved

 

[AYamshanov]

It would be helpful if you also post some short summary what problem was on the server and what solution was applied

 

[sistemisti]

the issue was related to user permission,i create 2 root users
one "create user 'root'@'%' IDENTIFIED BY 'supersecretpassword';"
and second "create user 'root'@'plesk_ip_server' IDENTIFIED BY 'supersecretpassword';"
i granted permission only to the user
grant all privileges ON *.* to 'root'@'%';
whene i grant the permission olso at the user
grant all privileges ON *.* to 'root'@'plesk_ip_server'; the db started to work