Articles in this section

See more

How to enable remote access to MySQL server in Plesk?

Avatar
Anastasiia Zyrianova
Updated
Follow
Plesk for Windows kb: how-to Plesk for Linux ABT: Group A FR:PPM-2313

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

How to enable remote access to a MySQL database server in Plesk?

Answer

Warning: After enabling the access, all MySQL connections will be unencrypted. To make them encrypted, an SSL certificate is required. For that and additional steps check this link: https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html#using-encrypted-connections-server-side-configuration

Note: Make sure that MySQL port is not blocked by a firewall: How to open all ports on local server needed by Plesk automatically?

When firewalld is enabled the following command may be used to open the port:

# firewall-cmd --zone=plesk --permanent --add-port 3306/tcp

By default, Plesk administrator does not have remote access. It is recommended to create a new user that will be used for the remote connection. Though user admin can be used, too.

In order to enable remote access to a MySQL server follow the instructions below:

Plesk Obsidian for Linux:

  1. Log into Plesk.

  2. Go to Tools & Settings > Database Servers > Settings > click on the Local MySQL Settings link:
    L1.png

  3. Select the Allow local MySQL server to accept external connections checkbox and click OK to apply changes:
    L2.png

Allow remote access to MySQL database server in Plesk for Linux and Plesk for Windows for a specific user:

  1. Log into Plesk.

  2. Go to Subscriptions > example.com > Databases > User Management > example_db_user.

  3. Make sure that the Access control option is set to Allow remote connections from any host or to Allow remote connections from:
    1.png

  4. Connect to the server via SSH/RDP.

  5. Open the MySQL configuration file in any text editor. The location of this file is:

    • For Linux:

      • for CentOS/RHEL-based distributions:
        /etc/my.cnf

      • for Debian/Ubuntu-based distributions:

        /etc/mysql/my.cnf

    • For Windows:
      %plesk_dir%Databases\MySQL\my.ini

  6. Change/add bind-address parameter to:

    CONFIG_TEXT: bind-address = 0.0.0.0

    0.0.0.0 means every IP address on the server. If it is required to bind to a specific IP address, specify this particular IP instead of 0.0.0.0

    Note: Make sure that skip-networking parameter is not defined in MySQL configuration file.

    Note: The bind-address directive may also be specified in the /etc/mysql/mariadb.conf.d/50-server.cnf file. If it is, make sure it is pointing to 0.0.0.0 instead of the loopback address.

  7. Restart MySQL server:

    • For Linux:

      # service mariadb restart || service mysql restart

    • For Windows:

      Start Plesk Services Monitor > select MySQLXX or MariaDBXX (where XX is a version) > click Restart.

To verify connectivity, log in from the remote server using MySQL Workbench or via CLI by executing the following command:

# mysql -u"example_db_user" -p"password" -h"example.com"

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles