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:
Login to Mysql Server:
# mysql -uadmin -p
Grant access to remote IP address and login to MySQL. For example, if you want to allow access to database called
user-password-hereand remote IP address
10.10.0.2, do the following:
mysql> GRANT ALL ON database.* TO user@'10.10.0.2' IDENTIFIED BY 'user-password-here';
mysql> FLUSH PRIVILEGES;
IP can be replaced with % to allow this user to logon from any host or IP.
- If connection still fails, check "bind-address" option in
*bind-address * option is IP address to bind to.