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 internal IP address of the server your database is on
- The username/database name that you want to connect to
- Your 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 clicking the MySQL Databases button on your Manage Website page.
On this page you will be able to find your database name and the Internal IP address.
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 IP Address 220.127.116.11
For the Port, we take the last 2 digits of the Internal IP Address of your database and put 33 at the beginning.
For example, in the above example pictures the Internal IP Address of the database is 10.168.1.50. So the port we will be connecting to is 3350
And that's it! You now have all the information you need to remotely access your databases.