How to Remotely Connect to the MySQL Database in cPanel?

Before using either of the following techniques, you will need to open up port 3306 in your server’s firewall.

You will need to add any IP address you will be connecting to MySQL from to the Access Hosts list in cPanel >> Databases >> Remote MySQL. This interface controls which remote hosts are allowed to connect to databases on the cPanel account remotely.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Run OPTIMIZE TABLE to defragment tables for better performance

For this suggestion:Run OPTIMIZE TABLE to defragment tables for better performanceRun this...

How to clear Error Log of a cPanel Account.

User the below code to clear Error Log:Replace User with Username:Code:for i in `find...

What is php.ini ?

The php.ini file and changing PHP Settings The php.ini file is a special file for PHP and...

How to fix ini_set() has been disabled for security reasons

1. Create php.ini file inside your public_html folder, OR the folder in which you have...

How to fix Fatal error: Uncaught exception 'Exception' with message 'DateTimeZone:

1: Create .htaccess file inside your public_html folder, OR the folder in which you have...