Remote MySql Database Connection Setup

Important: If connecting from your own home computer means remote MySql database connection, you will need a MySQL client like Navicat, phpMyAdmin, Workbench or Dreamweaver.

See our article on Managing Your Database with Applications for most suggested programs and much more details.

Configuration Settings:

Host name = (use the server IP address)
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.

remote-mysqlUtilizethe following configuration settings to plug in your database-

For adding vital string to your Perl or PHP code using these configuration settings, please see: MySQL Connection Strings-
Allowing an online Server to gain access to Your Database-

Before connecting to MySQL from another computer, the connecting computer have to be enabled being an Access Host.

Log into cPanel and then click the Remote MySQL icon, under Databases.
Type in the connecting IP address, and click on the Add Host button.
Note: You will find and add your IP address completely from this tool. Search Your IP is: [Add]. Clicking the [Add] link will input your IP in the field box below.
Click Add, and you ought to easily be able to connect remotely on your database.

Removing Access to get a Remote Server gain access to Your Database:

To clear out a number from accessing databases on your own server:

Click on the X icon next to the IP address.
If you are sure you need to prevent the server from accessing your databases, click Yes.
Dynamic IP Addresses

Which has a dynamic IP address signifies that the connecting IP address can change periodically according to the Isp (ISP). You need to update the connecting IP in Remote MySQL every time it changes.

Managing Your Remote MySql Databases

After whitelisting the IP permitting remote connection, you ought to be capable of making the proper remote MySQL connection with the database's name and user found in the cPanel's MySQL Databases page. The commonest overuse injury in connecting is because of an incorrect username and/or password. Please ensure the username you make use of matches the username created in the "MySQL Database" section of your cPanel.

Himanshu is a young engineer living in India. Currently working at Cognizant as a Senior Engineer. He is an ethical hacker & blogger too, doing lots of crazy stuff... If you seem interesting, go through his portfolio: : "Open Source. Millions of open minds can't be wrong!

Leave a reply:

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Site Footer

Sliding Sidebar

We are India’s largest Startup Community

We are team of ' Delhi Startups ' , most active startup community with strict spam policy.
We are making !deas happen..for future, business and jobs without charging anything, with connecting entrepreneurs.. It's a reason to trust on us.
Come and join or subscribe, we will defiantly give a reason to like us.

Our Facebook Page