Remote Access To MySQL Database Server?

Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306

How to add yourself to the whitelist so that you can connect to MySQL remotely.
  1. Log into your cPanel
  2. Click on the 'Remote MySQL' icon under the databases category
  3. Type the IP you are connecting from in the box. (You can get your IP by browsing to http://whatismyip.org)
  4. Click on 'Add Host'
Your done! You should now be able to connect successfully to port 3306 on your server.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database: Locally - from a script on the...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:- Login to your control panel...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...