InMotion Hosting Support Center

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.

Support Center Login

Social Media Login

   
Social Login Joomla

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
24,082 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
n/a Points
2015-01-03 4:47 pm

how can i connect netbeans and heidisql?

 

Staff
38,359 Points
2015-01-05 12:54 pm
Hello Vijayan,

Are you asking how to connect netbeans to heidisql? HeidiSQL is an application to connect to a database, so connecting to netbeans may not be possible.

Kindest Regards,
Scott M
n/a Points
2015-01-06 1:37 am
then what is the solution?
Staff
38,359 Points
2015-01-06 9:01 am
Hello Vijayan,

What is it exactly you are trying to do?

Kindest Regards,
Scott M
n/a Points
2015-01-21 7:23 am

Hello,

 

How I can add the SID so I can use it for the connection!

 

Thanks in advance!

Staff
33,582 Points
2015-01-21 10:52 am
Hello Anilak,

Thanks for the question. We are not sure what you mean by SID - I'm assuming Server ID? Server is designated only by Hostname or IP in HeidiSQL. Login credentials are based on the user and password that has access to the website. SSL details are found under the advanced tab. There are no options to SID that we know of. If you require further information or assistance, please provide more details on the SID and we can investigate the matter further.

Kindest regards,
Arnel C.
n/a Points
2015-02-12 4:45 am

Salutations 

With regards to the above question on connecting to netbeans think what my friend was saying is it necessary to have a code to connect the Heidi sql database to Netbeans IDE like in the case of connecting Netbeans with Xampp Database.

For a better understanding to what i mean, i have a code below that i used for connecting the two before:

import java.sql.Connection;

import java.sql.DriverManager;

import javax.swing.*;

public class javaconnect  {

    

    Connection conn=null;    

  

    public static Connection ConnecrDb()/*method*/

            

            

    {

   

        try{

            Class.forName("com.mysql.jdbc.Driver");

            Connection conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost/mkulimahodari", "root","root");

            JOptionPane.showMessageDialog(null,"Connection Established");//Will be displayed if a good connection occurs with the database

             return conn;

           

        }

        catch(Exception e) {

            JOptionPane.showMessageDialog(null,e);//if any error should occur it will show the error in the form of a dialogue box

       javaconnect s = new javaconnect();

s.conn();

            

            return null;

           

        }

        

 

    

    }

 

    private void conn() {

        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.

    }

Thank you in advance

 

 

Staff
38,359 Points
2015-02-16 10:11 am
Hello Philip,

I am not aware of any way to connect Netbeans and Heidi SQL. I have also done a bit of searching and do not see any instructions on connecting these two software.

Kindest Regards,
Scott M
n/a Points
2015-10-18 10:59 pm

dear philip,

it really helps me....thank you for this sharing moment but i just want to know where to put that code onto? Thank you for this sharing moment

regards shahida

 

n/a Points
2015-10-07 1:16 pm

How do you save a password in heidisql??it asks me everytime i start it...

Staff
33,582 Points
2015-10-08 7:21 am
Hello Sagar,

Everytime you create a new session in HeidiSQL you have the option to save it, and it includes a password. If you're repeatedly entering a password, then it may be related to another security issue. Check out HeidiSQL's documentation for further information.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.
Staff
11,216 Points
2015-11-06 9:40 am
HeidiSQL is a desktop client. PHPMyAdmin is a web based client for MySQL & MariaDB. You can do it, but you'll need to refer to their documentation. As for connecting MariaDB to HeidiSQL it's totall possible as well. Here's their guide on it: https://mariadb.com/kb/en/mariadb/heidisql/
n/a Points
2015-11-08 2:14 am

Your help was much indeed.

 

Thanks for the info.

n/a Points
2015-12-09 6:03 am

hi i tried with the above step but its not working giving error cannot connect tp mysql server on "hostname" (10060)

Staff
11,216 Points
2015-12-09 9:13 am
What are you using for your hostname? Is your server set up to connect using remote connections?
n/a Points
2015-12-10 12:33 am

i am using my domain name as a hostname. and how to check that either server set up to connect using remote connections or not

Staff
24,082 Points
2015-12-10 11:17 am
Hello Mukesh,

Thank you for contacting us. This is covered in the above section titled "Add IP to your Remote MySQL".

Thank you,
John-Paul
n/a Points
2016-04-11 12:28 am

hi,

i tried the connecting steps but its not connected...its throw error msg(cannot connect to mysql server on '127.0.0.1'(10061) )

Staff
38,359 Points
2016-04-11 3:45 pm
127.0.0.1 would be your local machine. Check your hsotname to ensure you are using a proper domain name or IP for the target server.
n/a Points
2016-04-27 7:51 am

how can i connect java clipse and heidisql?

Staff
24,082 Points
2016-04-27 8:35 am
Hello giovana,

Thank you for contacting us. We are happy to assist you, but it is not clear what you are trying to accomplish. Could you please provide some additional information so we can better assist you?

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.

23 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!