sistemisti
New Pleskian
- 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?
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?