- Plesk for Windows
- Plesk 12.0 for Linux
- While adding external database server, the following error is received:
Host 'server IP address' is not allowed to connect to this MySQL server
Or another error can be got:
Error: Access denied for user 'admin'@'mysql server IP' to database
Connection to MySQL is allowed from localhost by default. If Plesk should be connected to a remote MySQL server, grant MySQL
user privileges to manage a 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_IPwith 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.