For security reasons, Plesk doesn’t automatically make it possible to get remote MySQL access. We recommend that you create a new, separate user to use for remote MySQL connections. Nonetheless, if you prefer to do so, you can use the admin user account to facilitate remote MySQL access.
To enable MySQL remote access you must connect to your server with SSH/RDP and carefully follow the steps we list below:
Login to Plesk and make sure the option Allow remote connections from any host is enabled at Tools & Settings > Database Servers > Settings.
Connect to a Plesk server via SSH/RDP and open the MySQL configuration file in any text editor. Location of this file is:
For Linux:
- for CentOS/RHEL-based distributions:/etc/my.cnf
- for Debian/Ubuntu-based distributions:/etc/mysql/my.cnf
- Enter the following command: nano /etc/mysql/my.cnf
- Locate the line bind-address = 127.0.0.1 and replace it with bind-address = 0.0.0.0
- Press the CRTL + O keys and then press the ENTER key
- Press the CRTL + X keys to exit
- Type service mysql restart to restart MySQL
