Download Heidi SQLYour databases can be accessed not only with PhpMyAdmin in your cPanel; but, you can connect from your local computer with Heidi SQL. You can Download Heidi MySQL here for free.

Download Heidi SQL. After you download the HeidiSQL_7.0_Setup.exe file, install the program. Once you have Heidi SQL installed, follow the steps below to set up the Remote database connection.

Add IP to your Remote MySQL

In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel. You can get your IP address by going to the following link:

What's My IP address?

Connecting Remotely with Heidi SQL

  1. Open Heidi SQL.
  2. Click new Heidi SQLClick New.
  3. Name the connection Heidi SQLName the connection. Hit the enter key.
  4. Connection settings Heidi SQLEnter your connection settings. The settings should be like the following.

    Network type: MySQL (TCP/IP).
    Hostname / IP: You use your domain name or your server IP address.
    User: Your cPanel username or the database user you created.
    Password: Your cPanel password or the password for the database user.
    Port: 3306.
    Databases: Leave as Separated by Semicolon.
    Startup Script: Leave it blank.


  5. Open The Connection Heidi SQLClick Open.

    View the databases Heidi SQLNow you will see the databases and tables on your server.

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 this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

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!
Ask a Question
n/a Points
2014-11-19 10:20 am

 Can i use mysql server for heidisql??

Staff
10,380 Points
2014-11-19 11:12 am
Hello Abir,

Thank you for your question. Yes, by following the above guide you are able to connect to a MySQL server using heidiSQL.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

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

3 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!