How to connect Mysql database remotely?

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

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.

Was this answer helpful?

 Print this Article

Also Read

I want to change my cPanel Password.

To change your cpanel password use the following steps. Login to Filetruth Client Area.Click on...

How to solve "500 Internal Server Error"?

Your site can show "500 Internal Server Error" because of the following reasons - Main Reason...

How To Change PHP Version For My Hosting

How To Change PHP Version For My Hosting To change the PHP version of your hosting is very easy...

What Will Be The Host name for Mysql Database Connection

What Will Be The Host name for Mysql Database Connection Configuration Settings: Host =...

Why i am getting "This site can’t be reached"?

If your site is showing "This site can’t be reached" like above images then the reason is - Your...