How do I create remote access to my MySQL database on my VPS server?

Procédure

Why should I allow remote access to my MySQL database?

You can configure your MySQL server so that it can be accessed from a remote server. This can be useful if you want your database server to be separate from your web server or other servers.

How do I create remote access to my MySQL database on my VPS server?

If your VPS server was delivered after 1 September 2013, the MySQL service is basically open to the outside world: you can therefore skip steps 1, 2, 3 and 4.

1) Connect to your dedicated VPS server using SSH

2) Edit the MySQL configuration file using the following command :

  • on Debian 8 and 9 :
nano /etc/mysql/my.cnf
  • on Debian 10 systems :
nano /etc/mysql/mariadb.conf.d/50-server.cnf


3) Modify and save the :

Replace the following line :

How do I create remote access to my MySQL database on my VPS server?


with

How do I create remote access to my MySQL database on my VPS server?


Then save the file :

How do I create remote access to my MySQL database on my VPS server?


4) Restart the MySQL server to save your changes, using the following command:

How do I create remote access to my MySQL database on my VPS server?


5) Connect to your ISPConfig management panel, under the "Sites" tab, "Database" section, "Add a database" button:

How do I create remote access to my MySQL database on my VPS server?


6) Tick Remote Access, then add your IP address(find out your IP address here) in the Remote Access IP field.

If you want to authorise more than one, separate them with commas. Leave blank to authorise everything:

How do I create remote access to my MySQL database on my VPS server?


7) Finally, you will need to open TCP port 3306 in your server's firewall. To do this, connect to your LWS Customer Area,

How do I create remote access to my MySQL database on my VPS server?

8) Click on"Servers".

How do I create remote access to my MySQL database on my VPS server?

9) Click on"Manage" behind the server for which you want to open the port.

How do I create remote access to my MySQL database on my VPS server?

10) Then select"Firewall":

How do I create remote access to my MySQL database on my VPS server?

11) Click on the"Open a new port or port range" button.

How do I create remote access to my MySQL database on my VPS server?

12) Specify the TCP port you want to open and click on the"Validate" button to save your request.

How do I create remote access to my MySQL database on my VPS server?

Video procedure


I want a technician to activate and configure remote access to the MySQL service on my VPS server. How do I do this?

For people who don't want to connect directly via SSH (it's easy to make a handling error), LWS offers managed services.

There are two solutions: either you have subscribed to a support option: this intervention is included in your package --> simply open an incident ticket with the technical department to indicate which IP(s) should be authorised.

Or, you can set up a one-off managed service: a technician will call you back within the hour and carry out the work with you. The technician will take the time to answer your questions and explain the changes you have made.

Rate this article :

5/5 | 1 opinion

This article was useful to you ?

Article utileYes

Article non utileNo

Vous souhaitez nous laisser un commentaire concernant cet article ?

Si cela concerne une erreur dans la documentation ou un manque d'informations, n'hésitez pas à nous en faire part depuis le formulaire.

Pour toute question non liée à cette documentation ou problème technique sur l'un de vos services, contactez le support commercial ou le support technique

MerciMerci ! N'hésitez pas à poser des questions sur nos documentations si vous souhaitez plus d'informations et nous aider à les améliorer.


Vous avez noté 0 étoile(s)

Similar articles

2mn reading

How do I create a database in ISPConfig?

0mn reading

How do I change the password for my ISPCONFIG DB?

0mn reading

How do I connect to the PHPMyAdmin utility from ISP Config?


Ask the LWS team and its community a question