- Plesk for Windows
- Plesk 12.0 for Linux
- While adding external database server, the following error is received:
PLESK_ERROR: Host 'server IP address' is not allowed to connect to this MySQL server
PLESK_ERROR: 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, it is needed to 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. Make sure that port 3306 is opened on the server that is running MySQL Server.