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
Before we set up a connection you must download and then install the HeidiSQL client.
- You can Download HeidiSQL here for free.
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.
You can get your IP address by going to the following link:
Connecting Remotely With HeidiSQL
- Open HeidiSQL.
- Click New.
- Name the connection. Hit the enter key.
- 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.
Databases: Leave as Separated by Semicolon.
Startup Script: Leave it blank.
- Click Open.
Now you will see the databases and tables on your server.
Congratulations, now you know how to remotely connect to MySQL using the HeidiSQL database client. See our section on working with databases for more helpful tutorials.