Connect to Mysql with Heidi SQL
Your 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:
Connecting Remotely with Heidi SQL
- Open Heidi SQL.
- 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.
We value your feedback!
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.
new! - Enter your name and email address above and we will post your feedback in the comments on this page!
2014-11-19 11:12 am
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.