The Remote MySQL feature access allows remote hosts (servers) to manage your databases in the Agency plan. To set it up, first, you need to allow the desired remote IP to connect to your database.
Allow a remote IP to access your database
This can be done by accessing Websites → Dashboard, searching for Management under Database on the left sidebar, and clicking on it:
There you can select to add a new MySQL user:
And there you will be able to fill in the needed information:
- Database username
- Database password
- 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
- When all is good to go, click on “Add remote user”
Manage remote access
After the remote access is created, you will be able to manage it:
That’s it! Now you know how to set up and manage remote access to your databases on Agency plan 😊