Article ID: 1134, created on Oct 6, 2008, last review on Oct 12, 2016

  • Applies to:
  • Plesk


How to enable remote access to MySQL database server?


MySQL users and databases are created in Plesk with permissions that allow access to the database externally. To enable remote access to MySQL, follow instructions:

  1. Login to Mysql Server:

    # mysql -uadmin -p
  2. Grant access to remote IP address and login to MySQL. For example, if you want to allow access to database called database for user user with password user-password-here and remote IP address, do the following:

    mysql> GRANT ALL ON database.* TO user@'' IDENTIFIED BY 'user-password-here';

    IP can be replaced with % to allow this user to logon from any host or IP.

  3. If connection still fails, check "bind-address" option in /etc/my.cnf or /etc/mysql/my.cnf files.

    bind-address option is IP address to bind to.

Search Words

remote access MySQL

remote access to MySQL

Host is not allowed to connect to this MySQL server

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF