November 25, 2019
November 25, 2019
HeidiSQL is an all-in-one tool for database management, development, and administration. You may use HeidiSQL to remotely connect to a database created here on Hostinger. While our web hosting plans offer phpMyadmin to help with database management, HeidiSQL is the preferred choice for many developers. Using it can greatly speed up development. The remote MySQL connection made via your local machine will let you apply new updates and changes quicker, thus saving you the trip to the web hosting control panel.
Before you begin this HeidiSQL tutorial, you will need the following:
We assume you already have a HeidiSQL client installed on your local machine. So we will begin by explaining the steps to access a MySQL database created on Hostinger.
Firstly, locate your IP address using any online tool. One way to get it is by typing what is my IP in Google search engine. Here’s an example:
Next, navigate to Remote MySQL section in your web hosting control panel.
You will need to add your public IP there to allow the remote database connection. In this section, you’ll also find the remote MySQL hostname, which we will need later.
Once everything is filled in, press Create and you will see a confirmation message.
After that, the remote database access will work in a few seconds.
Secondly, you will need the database information. You can get the required credentials in MySQL Databases section in the control panel.
Since we already located the remote MySQL hostname in the previous step, we will only need the database name and user.
That’s all! We now have all we need to start configuring the HeidiSQL client.
Open the database client and press New to create an entry.
Then, you will need to name the entry and fill in the MySQL database configuration.
Make sure to complete the following fields:
Once done, press the Open button and you’ll be inside your database.
Congratulations! You can now access your databases remotely using a HeidiSQL client.
Sometimes mistakes or mistypes happen that can cause HeidiSQL client to show errors. Let’s discuss a few common ones and see how we can fix them.
The error occurs when using an incorrect MySQL port. It usually looks like this:
To fix it, review the port number in your HeidiSQL configuration. On Hostinger, this value is 3306. You may also contact your hosting provider as this value can differ.
The following error can happen due to incorrect MySQL hostname. It’s displayed as:
To get rid of it, double check if your remote MySQL hostname value is correct. On Hostinger, you may locate it in Remote MySQL section of the hosting panel.
This error can come in different forms and relates to incorrect details or missing IP entry in Remote MySQL section. Here’s one version of it:
If you see this error, try one of these 3 solutions:
The error may also look like this:
This indicates that your database name is wrong. Re-check the name in MySQL Databases section and update your HeidiSQL client configuration. As a result, you should have no problem managing your database.
For more MySQL basics and tutorials, check out these articles:
To sum up, there are various database management tools that can increase your work efficiency. In this tutorial, we have learned how to set up a remote MySQL connection via HeidiSQL client and fix basic connection issues.
Also, do you have any questions, tips, or ideas to share? You are welcome to do so in the comments below!