While adding external database server, the following error is received:
Host 'server IP address' is not allowed to connect to this MySQL server
Connection to MySQL is allowed from localhost by default. If Plesk should be connected to a remote MySQL server, grant MySQL
admin user previleges to manage database from specific IP address (from Plesk IP address).
Log in to MySQL database on the external database server.
Run the following queries:
mysql> GRANT all ON *.* TO admin@'plesk server IP';
mysql> FLUSH PRIVILEGES;
Note: replace the username and password with the actual admin credentials and 'plesk server IP' with actual Plesk IP address. Also, update firewall rules to make sure port 3306 is opened on the server that is running MySQL Server.
- Once you have completed the steps above, please try to add an external database server.