Remote MySQL is a feature that lets you specify which external servers (hosts) can connect to and manage your databases from remote locations.
To set it up on Agency hosting plan, first, you need to select the database that will be remotely accessed. This can be done by accessing Websites → Dashboard, searching for Management under Database on the left sidebar, and clicking on it:
Click on the arrow (>) icon next to the database you want to create the remote connection
Then, on the right sidebar, it will show a pop-up to create the remote database users by clicking Add remote user.
In the newly opened pop-up, you can create separate database users with different access hosts (IPv4, IPv6, or plain localhost), by filling the details:
- Database username – separate database users to access the selected database
- Database password – separate database password for the selected database
- Allowed hosts – the IP address from which the remote connection will be initiated
- Any Host – to allow the connection from any IP. This will add a % symbol in the IP field
When all is completed, click on Add remote user
You also can find the MySQL server hostname below the database list section:
That’s it! Now you know how to set up and manage remote access to your databases on Agency plan 😊