Skip to main content

Introduction

Initially FASTPANEL® configures MySQL server such way that connections are accepted only from the server itself (localhost). To enable external connections, you must first reconfigure the MySQL server.

Enabling remote connection to the MySQL server​

To add the ability to connect to databases remotely you need to configure the bind_adress variable in MySQL variables. You can edit these variables directly from FASTPANEL: management menu → Databases → Database Servers → Configure variables

Database servers management in FASTPANEL

Edit database server settings in FASTPANEL

The bind-address variable, which by default has the value 127.0.0.1, is responsible for allowing the remote connection. You need to change this value using the "Edit" button, setting the value to * and click Save to apply the changes.

Edit mysql variable bind-address in FASTPANEL

After changing the value and clicking the "Save" button there is no need to restart the MySQL service.

You can also use the search to find mysqlx-bind-address, this is the equivalent of the bind_adress variable for the X Plugin. It represents the network address where the X Plugin is listening for TCP/IP connections. This variable is not dynamic and can only be set at startup.

Database user with remote connection​

Open management menu → "Databases" → "Editing a database user" and set flag on "Remote connections":

Enable database remote connections in FASTPANEL