Tuesday, October 14, 2014

Configuration of Remote mysql in cPanel

Follow the steps below to connect your Database from a remote client running in your PC.

For that configure the following parameters in your remote client.

Host name = Put your server IP here (Eg :64.20.23.56)
Database name = cpanelUsername_databaseName
Database username = cpanelUsername_databaseUsername
Database password = the password you entered for that database user
MySQL Connection Port = 3306
TCP or UDP, either is fine.


Also you need to allow your public IP address in your cpanel.Please follow the below instructions to do the same.

Log into cPanel and click on "Remote MySQL" under the Databases Heading.
Next, you'll need to add your IP address into the field on the page and select "Add Host". (You can find your IP here in this link http://cpanel.net/myip)


No comments: