How to Connect to the MYSQL Database Remotely?

Allowing remote MYSQL connections is often done to enable a program on your personal computer to access a database on the server.

1. Download navicat free software here & install it on your computer.
https://www.navicat.com/en/download/navicat-for-mysql/

2. Login into your cPanel Account.
In the Databases section, click Remote MySQL.
In the Host field, enter the IP address from where you want to access your databases. (Find Your IPV4 Address Here)
You can enter something like 1.2.3.% if you want to allow a range if IP addresses.
Click Add Host.

Configuration Settings:
Use the following configuration settings for connecting to your database:

Field What to Enter
Connection Name Enter Your Connection Name
Hostname Enter Shared IP Address/Domain Name
Port 3306 (Default)
DB Username Database user's username
DB Password Database user's password


Now Let's Connect to Databases Remotely From Computer Using Navicat Software.
Click on Connection Button and in dropdown list click on MySQL.

Remote MYSQL 1

Now here just enter connection details as showing in above configuration table.

Remote MYSQL 2

You can also Click on "Test Connection" Button in Order to verify Remote MySQL Connection Status.

Remote MYSQL 3

As per Test Connection it gives Successfull Connection Notification, Just click save and this connection will be added in your MySQL Connection List. 
Now you need to Click on saved connection and click Open Connection so that it begins to access Database Remotely. 

Remote MYSQL 4

As we have now open this remote connection successfully and it is showing MySQL Database Name.

Remote MYSQL 5

Just click on Database Name to Explore it and you will see all relevant fields of this Database, E.g. Tables, Views, Function etc..
To access any table of this database click on Tables > Table Name, It will show you all records of this table as showing in picture below. 
You can Add, Edit, Delete any fields or records by clicking on that field. 

Remote MYSQL 6

That's All

  • connect mysql database remotely, mysql, database
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to configure your domain email on Gmail app ?

Log in to cPanel using your username and your cPanel password at http://yourdomain.com/cpanel,...

How to disable mod security using htaccess file?

Mod_security is an apache module that helps to protect your website from various attacks.It is...

Prevent Brute Force Attacks in WordPress

A brute force attack is a trial-and-error method in which the hackers aim to gain access to a...

How to fix failed to retrieve directory listing error in FileZilla FTP?

When using FileZilla to connect to your FTP if you encounter an error like this: Status:...

How To Fix 500 Internal Server Error in WordPress?

In this article, we will show you how to fix the internal server errors in WordPress. The...