Skip to main content

​
Remote connection

The first step is to obtain the IP address from which the remote connection is being established. You can retrieve this information from http://ip.me.uk/. Now access your cPanel account and click on Remote MySQL. On the next page, add the IP address in the Host field and, if necessary, attach a Comment. Once ready, click Add Host. At the bottom of the page you can find the existing IP addresses that are added to the Remote MySQL list, from which such connections can be established successfully.

​
Remote MySQL configuration

The settings you would need to use for establishing such a connection are as follows:
  • Hostname: your server name or the IP address of the server
  • Database: your database name
  • Username: your database username
  • Password: your database username’s password
  • Port: 3306
If asked for a Connection Method, select TCP/IP.
You can access it using software such as MySQL Workbench.