How do I remotely connect to my database?

gabe

7 years ago

This article will show you how to remotely connect to your hosting package’s databases.

Please note: this article only applies to Web Hosting plans purchased after July 2020 or Premium Hosting plans purchased after August 2020.

Before getting started, you will need your database’s username and password, your server’s hostname/IP address as well as your own IP address. If you’re not sure where to find these details, please read the following articles:

Step 1 of 8

Start by installing a MySQL client.

If you’re using cPanel, we recommend HeidiSQL or MySQL Workbench. If you’re using Plesk, we recommend SQL Server Management Studio (SSMS).

Step 2 of 8

Once done, access your Web Hosting dashboard.

Step 3 of 8

From there, click cPanel Admin.

Step 4 of 8

On the next page, click Remote MySQL within the Databases section.

Step 5 of 8

You will now see a list of access hosts that can connect to your database. Enter your own IP address into the Host field and click Add Host.

Step 6 of 8

You will then see a confirmation message, informing you that your access host has been added.

Next, open your MySQL client and start a new session.

Step 7 of 8

Give your connection a name and then enter the following details:

Hostname/IP: your server’s hostname/IP address
Username: your database’s username
Password: your database’s password
Port: leave this as 3306

Once you’ve done this, click Open.

Step 8 of 8

You will now be connected to your database.