Many site owners have a developer working with them. In many cases, the owners will not wish to give full cPanel access to the developer. This can hinder the developer from working on specific things such as the database. While there are ways to allow access to the phpMyAdmin tool, the owner needs to do a bit of setup and sacrifice more space on the account. Another solutionto this problem is to allow the developer to connect with a remote database management tool, such as HeidiSQL. This article describes how to use HiediSQL to remotely connect to a database on your hosting account.

Enable remote connection in the cPanel

Before you can connect to your databases with any remote connection you will need to set your cPanel to accept connections from the IP address of the computer you want to work with. Below is a link with instructions on setting that up.

How to set up a remote MySQL connection.

Download and install HeidiSQL

  1. First, download HeidiSQL. You can get the latest version from www.heidisql.com/download.php.
  2. Once downloaded, click on the installation application from your download folders for the program to install.
  3. installation wizardFollow the wizard to install HeidiSQL to your local machine.
     

Making your remote connection

Now that you have set the cPanel to accept the connecting machine's IP and installed HeidiSQL, it is time to set up the profile to make the connection.

  1. Open the HeidiSQL application.
  2. 1-click-newClick on the New button found in the lower left corner.
     
  3. name the sessionThe lefthand panel will create a default name and highlight it. Enter a new name for this profile and hit Enter.
     
  4. enter connection settingsThe right hand panel has several fields for you to enter connection information.
    Network Type MySQL (TCP/IP)
    Hostname/IP This is either the domain name you are connecting to, or the IP address of the server.
    User This is either the cPanel username or the specific username created for the database.
    Password This is the password for the username above.
    Port 3306
    Databases Leave this blank and the available databases for your username will appear once logged in.
    Startup Script Leave this field blank.
     
  5. after successful connectionOnce you have entered your connection information, click the Open button from the lower right corner. This will open the connection to the server and list your databases on the left.
     
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

News / Announcements

Update to SSL Certificates - Certificate Warnings
1969-12-31 11:00 am EST
Hits: 671

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.