Knowledgebase
How can I access to my MySQL / MsSQL database remotely?
Posted by Sinan Esen on 22 April 2015 03:59 PM

1. Firstly create a database and a database user through your control panel :

 

  • Please find the instructions here

 

2. You will then need to add your IP address to our SQL Firewall rules as follows:

 

  • When prompted for a username and password, enter your hosted website's FTP credentials
    NB: If you do not remember your FTP credentials, follow these instructions

 

  • Your IP address will then be automatically registered

 

3. You can now access your databases remotely via:

  • TCP port 1433
  • TCP port 3306

 

NB:

  • If you are using a dynamic IP address, you will have to re-register your IP address each time your ISP releases it.
  • If you have a static IP address, you will have to re-register it on a weekly basis when all IP addresses are flushed.
(6 vote(s))
Helpful
Not helpful