How To Setup Remote Database Connection - Configure MySQL client Access
If you are using assistive technology and are unable to read any part of the HostMonster website, or otherwise have difficulties using the HostMonster website, please call 866-573-HOST and our customer service team will assist you.
Skip to main content
Search

HostMonster Web Hosting Help

How To Setup Remote Database Connection - Configure MySQL client Access

Note: If connecting from your home computer, you need a MySQL client like Navicat, phpMyAdmin, Workbench or Dreamweaver.

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

Configuration Settings:

Use the following configuration settings for connecting to your database

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.

For adding a connection string to your Perl or PHP code using these configuration settings, please see: MySQL Connection Strings

Allowing a Remote Server to Access Your Database

Before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.

  1. Log into cPanel and click the Remote MySQL icon, under Databases.
  2. Type in the connecting IP address, and click the Add Host button.
    • Note: You can find and add your IP address directly from this tool. Look for Your IP is: 123.123.12.123 [Add]. Clicking the [Add] link will input your IP into the field box below.
  3. Click Add, and you should now be able to connect remotely to your database.
​

Removing Access for a Remote Server to Access Your Database

To remove a host from accessing databases on your server:

  1. Click the X icon next to the IP address.
  2. If you are sure you wish to prevent the server from accessing your databases, click Yes.

Dynamic IP Addresses

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.

Managing Your Databases

After whitelisting the IP to allow remote connection, you should be able to make the proper remote MySQL connection with the database's name and user found in the cPanel's MySQL Databases page. The most common problem in connecting is due to an incorrect username and/or password. Please make sure the username you use matches the username created in the "MySQL Database" section of your cPanel. For examples of MySQL errors, please see the related article: MySql Errors

You will need a third party application to access MySQL remotely. Some are free and some cost money. For a list of applications, you may want to visit our page on:
Knowledgebase Article 1,178,271 views bookmark
share
Share or save this via:
tags: connection database mysqlfront remote


Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

Local MySQL Connection Blocked To Server
I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostMonster.com' is blocked because of many connection errors; unblock with 'mysqlad
Knowledgebase Article 265,416 views tags: blocked connection host localhost mysql

MySQL Database and user name convention
I cannot connect to my database locally or remotely, do I have the correct server, username and password?
Knowledgebase Article 334,737 views tags: connect disconnected hostname mysql user

MySQL Database Access Outside of cPanel
How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password?
Knowledgebase Article 282,728 views tags: access grant mysql password permission

Related Help Content

Connecting to your MySQL DB from Dreamweaver
How can I connect to our MySQL database from Dreamweaver?
Knowledgebase Article 271,020 views tags: connecting database dream mysql weaver

Managing Databases with Applications
This article will go over different application available for remote connection to your databases.
Knowledgebase Article 241,210 views tags: database mysql

Connecting Scripts to MySQL Databases
This article will explain how to connect your scripts to your MySQL databases.
Knowledgebase Article 237,142 views tags: database mysql scripts

Setting a Password for the Main MySQL User
I am prompted to set a new MySQL password. What does this mean and how do I change it?
Knowledgebase Article 249,374 views tags: connect database mysql password phpmyadmin username

How to Create and Delete MySQL Databases and Users
This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 873,681 views tags: creation database mysql

MySQL Connection Strings
This article will describe connections strings, what they are used for, and give examples.
Knowledgebase Article 275,728 views tags: connection databases mysql

Whitelist IP Address
How do I Whitelist my IP Address? I can't log into MySQL from a remote computer using a MySQL admin tool (phpMyAdmin, Navicat, MySQLFront, MySQL-Admin, etc).
Knowledgebase Article 346,528 views tags: address ip list remote white whitelist

MySQL Database Compatibility
How do I make my MySQL database compatible with the version you provide?
Knowledgebase Article 245,415 views tags: compatible database mysql

This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here