Theme editor

Guide Plesk Enabling Remote MySQL Access on Plesk Panel – Complete Guide 2025

  • Thread starter Thread starter CL4Y
  • Start date Start date
  • Views 136

CL4Y

Keyboard Ninja
Administrator
Thread owner
If you need to access your database from an external source, you must enable remote connections for MySQL.
On servers running Plesk Panel, you can enable it by following the steps below.



🔧 1. Connect via SSH and Edit MySQL Configuration

Bash:
nano /etc/my.cnf
NOTE: On some operating systems, the configuration file may be located at /etc/mysql/my.cnf instead.

jetto-plesk-remote-sql-connect-1.webp


Locate the following lines:
Code:
bind-address
skip-networking

jetto-plesk-remote-sql-connect-2.webp


Comment them out by adding a “#” at the beginning:
Bash:
#bind-address
#skip-networking
NOTE: In some my.cnf files, skip-networking may not exist. If that’s the case, no additional action is needed.

These changes will allow MySQL to accept external (remote) connections.



🔁 2. Restart the MySQL Service​

Bash:
service mysqld restart
If your system uses mysql or mariadb instead of mysqld, try the following:

Bash:
service mysql restart
or
Bash:
service mariadb restart

jetto-plesk-remote-sql-connect-3.webp
 
Thread owner
Your MySQL database on this server can now be accessed remotely.
If you encounter any issues, please let us know so we can assist you. 🙂

Additionally, if you still cannot connect even after performing the above steps, your server might have a firewall enabled.
If you’re using a custom firewall, make sure port 3306 is open for external access.
However, if you’re only using the system’s default firewall, you can run the following commands to stop it:

Code:
service iptables stop
service firewalld stop
iptables -X
iptables -F
 
Back
Top