Accessing your MySQL or MSSQL databases remotely is made simple and easy when using our Cloud platform. All you will need to have to hand is:
- The IP address which you are going to be connecting from
- The remote access host for the server your database is on
- The database username and database name that you want to connect to
- Your database username's password
To ensure the security and legitimacy of your connection, you will need to add your IP address to the list of permitted IPs before our system will allow you access. If you're unsure how to find your IP address simply type “IP” into a Google Search.
If you are connecting to a MSSQL database, you will have been given your MSSQL database's details when it was first set up; If you aren't sure what they are just open a support ticket and we will be able to let you know.
If you are connecting to a MySQL database then you can find out what your database's details are by logging into your Cloud hosting account and clicking the MySQL Databases button on your Manage Website page.
On this page you will be able to find your database name and the remote access host (which is in the format [IP ADDRESS]:[PORT]). So in our example we'd want to connect to the IP address 220.127.116.11 over port 1170.
If your username is different to the database name, or if you don't know what your database password is, you can find that out/reset your password by using the Manage Users tab at the top of the page.
Now we have all that important information, our next step is to put it to good use!
First, make sure that your IP address has been added to the list of permitted IPs by heading to your Manage Website page and clicking on the Remote Access button.
Once that's done we're ready to connect remotely.
In your remote access program (such as Management Studio for MSSQL) you will be connecting to the remote access host IP address and port for your database which you learned above.
And that's it! You now have all the information you need to remotely access your databases.