Remote MySQL access allows remote hosts (servers) to manage your databases. To set up such remote access, first, you need to allow the desired remote IP to connect to your database. This can be done by accessing HostingManage, searching for Remote MySQL on the left sidebar, and clicking on it:

In the newly opened window, you will be able to create the new connection by filling in the details:

  • IP (IPv4 or IPv6) - the IP address from which the remote connection will be initiated

  • Any Host - click this checkbox to allow the connection from any IP. This will add a % symbol in the IP field

  • Database - select the database which will be remotely accessed

When all is good to go, click, on Create:

NOTE:

  • You can find the MySQL server hostname on top of the Create remote database connection section:

After the remote access is created, you will be able to remove it if needed on the Remote MySQL section:

That's it! Now you know how to set up and manage remote access to your databases 😊

Did this answer your question?