If you have employed a developer to help create your website, you may often want to present a solution to accessin the database without actually giving Cpanel access to the developer.  One of the free MySQL clients that can be used for this purpose is Heidi SQL.  The following article shows how download Heidi SQL and configure to access a MySQL database setup on your server.

 

Setting Up HeidiSQL to access MySQL databases in the Cpanel

 
Download and Install HeidiSQL

heidisql-download-siteBefore you begin, you can download HeidiSQL from here.  Click on the link that says INSTALLER. Install HeidiSQL by double-clicking on the HeidiSQL_7.0_Setup.exe file that  you download.  When the installation completes, you will have the option to run the program and read the readme file.  Go ahead and run the program and then go to the next part in accessing the database.

 

Configuring RemoteMySQL in Cpanel

Before you can connect to the database using HeidiSQL, you will need to create an entry in Remote MYSQL.  This allows the MySQL client to connect to the database.  You will need to obtain the internet IP address for the individual using HeidiSQL to access the database.  For more information using Remote MySQL, please go to How to use Remote MySQL. If you are unsure of your IP address, use this link:   Find my IP address. Once you have the IP address, then you can add the IP address to the Remote MYSQL section as per below:

 

  1. Login to the Cpanel.
  2. Remote Access screenScroll down until you find the database section.  Click on REMOTE MYSQL.
     
  3. In the blank field under ADD ACCESS HOST and next to Host(% wildcard is allowed):,  type in the IP Address.  And click on ADD HOST.  If you have more than IP address, then add them one at a time.

 

Configure HeidiSQL to Connect to the Database

In order to configure this section, you will need to obtain the user name and password that you used when you created the database.  The user name and the password do not need to be the original user name and password.  You can also create a new user and assign that user to the database.  In either case, the user should have complete access to the database.

  1. heidi-sql-interfaceRun HeidiSQL.
     
  2. Click on the NEW button at the bottom of the screen.
  3. Type in a name for the Session.
  4. In the right side of the screen, type in the IP address of the web server or the domain name (the website name).  Note that the Network Type, and Port number are set to MySQL (TCP/IP) and Port 3306 respectively.  You can leave the rest of the settings to default.
  5. Click on the USER field and type in the database User that had been assigned to the database in MySQL (in the Cpanel).
  6. Click on the PASSWORD field and type in the password assigned to the user to access the database.
  7. Click on OPEN in order to start the session.


HeidiSQL is a full featured editor and will allow you and edit the tables in the database structure.  Here's an example of what you will see when using HeidiSQL:

HeidiSQL viewing a MySQL database

 

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: 659

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.