Article ID: 124939, created on Mar 19, 2015, last review on Oct 9, 2016

  • Applies to:
  • Plesk Automation 11.5
  • Plesk 12.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 10.4 for Windows


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).


  1. Log in to MySQL database on the external database server.

  2. Run the following queries:

    mysql> GRANT all ON *.* TO admin@'plesk server IP';     

    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.

  3. Once you have completed the steps above, please try to add an external database server.

Search Words

ERROR: PleskMainDBException: Host '' is not allowed to connect to this MySQL server (db.php:435)



cant access the mysql remotely

Host is not allowed to connect to this MySQL server

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079 85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 ff5a00b8ead2e480367b019417a04207 c796c01d6951fa24ed54c7f1111667c6 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF