---
title: "Connect to MySQL With HeidiSQL"
description: "Not only can you access your databases with phpMyAdmin in your cPanel, but you can connect from your local computer using a database client such as HeidiSQL. This is also a great way to allow your..."
url: https://www.inmotionhosting.com/support/server/databases/connecting-heidi-sql-database/
date: 2013-03-01
modified: 2022-05-18
author: "InMotion Hosting Contributor"
categories: ["Working with Databases"]
type: post
lang: en
---

# Connect to MySQL With HeidiSQL

![Learn How to Connect to MySQL With HeidiSQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/Connect-to-Mysql-With-HeidiSQL-2-1024x538.png)

Not only can you access your databases with phpMyAdmin in your cPanel, but you can connect from your local computer using a database client such as **HeidiSQL**. This is also a great way to allow your developer to manage a database directly without giving them full access to your cPanel.

There are several steps to connecting to MySQL with HeidiSQL. First, you must download and install the free HeidiSQL app also known as a database client. Next, set up the remote database connection, which adds the IP address of the person connecting to the firewall and allows them to access the database. Finally, you will learn **how to use HeidiSQL to connect to your MySQL database**.

- [Download & Install HeidiSQL](#install-heidi-sql)
- [Add IP to Your Remote MySQL](#add-ip)
- [Connecting Remotely With HeidiSQL](#connect)

## Download & Install HeidiSQL

Before we set up a connection you must download and then install the HeidiSQL client.

- You can [Download HeidiSQL here](https://www.heidisql.com/download.php) for free.

![](https://www.inmotionhosting.com/support/wp-content/uploads/2022/05/download-heidisql.png)

## 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 Remote MySQL in cPanel. This allows your specific computer to get through the firewall and access the database.

- [Setting up a Remote MySQL Database Connection](https://www.inmotionhosting.com/support/website/setting-up-a-remote-mysql-connection-in-cpanel/)

You can get your IP address by going to the following link:

- [What’s My IP address?](https://www.inmotionhosting.com/support/tools/what-is-my-ip-address/)

## Connecting Remotely With HeidiSQL

1. Open **HeidiSQL**.
2. Click **New**.![Click New - Heidi SQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_heidi-sql-download_heidi-database-2-click-new.gif)
3. Name the connection. Hit the enter key.![Name the Connection - Heidi SQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_heidi-sql-download_heidi-database-3-name-connection.gif)
4. Enter 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.![Connection Settings Heidi SQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_heidi-sql-download_heidi-database-4-connection-settings.gif)
5. Click **Open**.![Open The Connection Heidi SQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_heidi-sql-download_heidi-database-5-open-connection.gif)Now you will see the databases and tables on your server. ![View the databases Heidi SQL](https://www.inmotionhosting.com/support/wp-content/uploads/2013/03/website_databases_heidi-sql-download_heidi-database-6-view-databases.gif)

Congratulations, now you know how to remotely connect to MySQL using the HeidiSQL database client. See our section on [working with databases ](https://www.inmotionhosting.com/support/server/databases/)for more helpful tutorials.