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.
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?
What Will Be The Host name for Mysql Database Connection Configuration Settings: Host =...
To change your cpanel password use the following steps. Login to Filetruth Client Area.Click on...
Your site can show "500 Internal Server Error" because of the following reasons - Main Reason...
How To Change PHP Version For My Hosting To change the PHP version of your hosting is very easy...
If your site is showing "This site can’t be reached" like above images then the reason is - Your...