Download & Install HeidiSQL

Download & Install HeidiSQL

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

Add IP to Your Remote MySQL

Connecting Remotely With HeidiSQL

Download & Install HeidiSQL

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

You can Download HeidiSQL here for free.

https://www.heidisql.com/download.php

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.

Congratulations, now you know how to remotely connect to MySQL using the HeidiSQL database client.