How to connect Mysql database remotely?

Yes you can access Mysql remotely using any Mysql connectivity Software like Navicat.

First of all you need to whitelist the IP of the internet from which you want to access MySql

Steps to Whitelist Ip.
============================

1. Login to your cPanel.
2. Click on "Remote MySQL".
3. Under "Add Access Host" add your internet IP.
4. You can check your IP address from sites like https://www.whatismyip.com

To connect Mysql with Software you need following Details
============================================================

You need to create a Database and database user using "MySql Databases" option of cpanel and provide user access of Database.
after that you can connect using following Details.

HostName/IP Address: IP Address of your hosting or you can use your Domain Name if nameservers are already propogated with our hosting.
Port: 3306
Username: Database username created by you.
Password: Database user password created by you.

Using these details you will be able to use Database Remotely.

 

 

If still you are Facing any issue Please Click Here to raise a ticket to our Support team

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

What Will Be The Host name for Mysql Database Connection

For Linux Hosting: Database Hostname is: localhost   For Windows Hosting: Database Hostname...

I Need a Different Mysql Version

I Need a Different Mysql Version In our different server we have diffrenet Version of Mysql . As...

Why I Am Getting Error Establishing a Database Connection Error

To solve this " ERROR ESTABLISHING CONNECTION" please follow the below steps:   1: This error...

How to create the "Database and Database User" in Cpanel?

To create the "Database and Database User" in Cpanel please follow the below steps:   1: Open...

How to connect to file zilla?

1: Open your filezilla.   2: On the top "quick connect" bar type your all details.   3: Host...