How to Remotely Connect to the MySQL Database
Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server.
For some suggested programs and more details, please see:
Please click the links below for more information.
- How To Enable Your Computer as an Access Host
- How To Manage IP Address as an Access Host
- What Are the Configuration Settings
- How To Access Your Databases
- Related Topics
- Related Articles
How To Enable Your Computer as an Access Host
By default, all IP addresses are blocked and added to a list to access the server. So, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.
Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP). You must update the connecting IP in Remote MySQL every time it changes.
How To Manage IP Address as an Access Host
Here is a video showing how to add your IP address as an Access Host in cPanel.
To add your computer as an Access Host:
- Log in to cPanel.
- Under the Databases section, click on the Remote MySQL® icon.
- On the Remote MySQL® page, enter the connecting IP address, then click Add Host.
To know what your current local IP address is, please visit hostgator.com/ip.
To remove a host from accessing databases on your server:
- Click the Remote MySQL® icon under the cPanel’s Databases section.
- Locate the IP address you wish to remove.
- Click the Delete icon on the right-hand side of the IP address.
If you have Windows hosting, you will need to whitelist your IP. Please follow the instructions in the following articles:
What Are the Configuration Settings
Use the following configuration settings to connect to your database.
|Hostname||Use the server IP address or server name. Please refer to this article to find your server address: What is My Server Address?|
|Database Name||Use the first 8 characters of your cpanelUsername_databaseName.|
|Database Username||Use the first 8 characters of your cpanelUsername__databaseUsername.|
|Database Password||The password you entered for that database user.|
|MySQL Connection Port||3306|
|TCP or UDP||Either of the two is fine.|
To learn more about adding a connection string to your Perl or PHP code using these configuration settings, please see the following article:
How To Access Your Databases
After whitelisting your local IP, you should be able to make the proper remote MySQL connection. Be sure that the username and password you will use match the ones created in the MySQL Database section of cPanel. The most common problem in connecting is due to the use of an incorrect username and password.
For more examples of common MySQL errors, please see the related article:
What Is a MySQL Database Server?
MySQL is an open-source management system used to create and manage databases. Basically, a MySQL server is like a database engine where you can store data and access and maintain those data systematically and efficiently.
How to Add a User to Access to the MySQL Database?
Aside from the configuration settings needed to remotely connect to a MySQL database, a user must also have certain privileges. Please refer to these articles to know more about granting privileges to users and configuring connection settings.
How to Allow Remote Access to a MySQL Server?
The MySQL server communicates only from the localhost by default, which means it can only be accessed by applications running on the same host. Remote access is necessary if you wish to remotely access the database from an application running on a different machine or host.
To remotely connect, you will need to get your connecting computer enabled as an Access Host by whitelisting your local IP address. You will also need to identify your configuration settings, as shown above.
How Do You Find the MySQL Hostname?
The MySQL Hostname is the location of your MySQL server and database. This information is needed whenever you need to remotely connect to your MySQL server. Localhost is used by default as the hostname provided that you are accessing your database on the same server where your application is, like WordPress. For a WordPress site, your hostname is found in your directory root’s wp-config.php file.
To remotely access the database, you may want to use your server IP address or server name instead of localhost to initiate a connection.
How Do You Restore a MySQL Database?
The cPanel has a feature that allows you to restore a MySQL Database backup. The instructions on restoring a MySQL backup are outlined in this article, Download and Restore MySQL Database Backup.
Alternatively, you also have the option to do a restoration through your cPanel’s phpMyAdmin by importing your backed-up MySQL database file. Please refer to the article below for instructions. A video guide is also included in the article to assist you with the whole process.