{"id":8240,"date":"2018-02-07T21:47:37","date_gmt":"2018-02-07T21:47:37","guid":{"rendered":"https:\/\/www.hostinger.com\/tutorials\/?p=8240"},"modified":"2026-03-09T19:20:04","modified_gmt":"2026-03-09T19:20:04","slug":"heidisql-remote-mysql-connection","status":"publish","type":"post","link":"\/ng\/tutorials\/heidisql-remote-mysql-connection","title":{"rendered":"How to use HeidiSQL to connect to a MySQL database"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><p>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 <a href=\"\/ng\/web-hosting\">web hosting plans<\/a> 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.<\/p><p>Before you begin this HeidiSQL tutorial, you will need the following:<\/p><ol class=\"wp-block-list\">\n<li>HeidiSQL client<\/li>\n\n\n\n<li>Remote MySQL entry for your IP address<\/li>\n\n\n\n<li>MySQL database credentials<\/li>\n<\/ol><p>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.<\/p><figure class=\"wp-block-image size-large\"><a href=\"https:\/\/assets.hostinger.com\/content\/tutorials\/pdf\/How-to-Speed-Up-Your-Website-EN.pdf\"><img loading=\"lazy\" decoding=\"async\" width=\"2048\" height=\"566\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/public\" alt=\"\" class=\"wp-image-69260\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/w=2048,fit=scale-down 2048w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/11\/eBook-Speed-Up-your-website.png\/w=768,fit=scale-down 768w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/figure><h2 class=\"wp-block-heading\" id=\"h-step-1-allowing-a-remote-mysql-connection-from-your-ip-address\">Step 1 &ndash; Allowing a Remote MySQL connection from your IP address<\/h2><p>Firstly, locate your IP address using any online tool. One way to get it is by typing <strong>what is my IP<\/strong> in <a href=\"https:\/\/www.google.com\/\">Google<\/a> search engine. Here&rsquo;s an example:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/locating-public-ip-address-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"196\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/locating-public-ip-address-1.png\/public\" alt=\"Locating public IP address with online tools\" class=\"wp-image-8320\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/locating-public-ip-address-1.png\/w=638,fit=scale-down 638w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/locating-public-ip-address-1.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/locating-public-ip-address-1.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/a><\/figure><\/div><p>Next, navigate to the <strong>Remote MySQL <\/strong>section in your web hosting control panel.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"428\" height=\"316\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/hpanel-databases-remotemysql-sidebar.png\/public\" alt=\"Remote MySQL connection section in hPanel\" class=\"wp-image-80710\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/hpanel-databases-remotemysql-sidebar.png\/w=428,fit=scale-down 428w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/hpanel-databases-remotemysql-sidebar.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/hpanel-databases-remotemysql-sidebar.png\/w=150,fit=scale-down 150w\" sizes=\"auto, (max-width: 428px) 100vw, 428px\" \/><\/figure><\/div><p>You will need to add your public IP there to allow the remote database connection. In this section, you&rsquo;ll also find the <strong>remote MySQL hostname<\/strong>, which we will need later.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1135\" height=\"444\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/public\" alt=\"Create remote database connection section on hPanel\" class=\"wp-image-80718\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/w=1135,fit=scale-down 1135w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/hpanel-databases-remotemysql.png\/w=768,fit=scale-down 768w\" sizes=\"auto, (max-width: 1135px) 100vw, 1135px\" \/><\/a><figcaption class=\"wp-element-caption\">The MySQL server hostname found here will be required when connecting via HeidiSQL<\/figcaption><\/figure><\/div><ul class=\"wp-block-list\">\n<li><strong>IP (IPv4 or IPv6)<\/strong> &ndash; enter your public IPv4 or IPv6 address.<\/li>\n\n\n\n<li><strong>Database<\/strong> &ndash; select the MySQL database that you will connect to.<\/li>\n\n\n\n<li><strong>Any Host<\/strong> &ndash; select this if you want to allow any host to connect to your database remotely.  <\/li>\n<\/ul><p>Once everything is filled in, press <strong>Create, <\/strong>and you will see a confirmation message. After that, the remote database access will work in a few seconds.<\/p><h2 class=\"wp-block-heading\" id=\"h-step-2-gathering-mysql-database-details\">Step 2 &ndash; Gathering MySQL database details<\/h2><p>Secondly, you will need the database information. You can get the required credentials in the <strong>Databases &rarr;<\/strong> <strong>Management<\/strong> section in the control panel.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"440\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/01\/hpanel-databases-management-sidebar.png\/public\" alt=\"The Databases Management button in hPanel\" class=\"wp-image-80367\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/01\/hpanel-databases-management-sidebar.png\/w=440,fit=scale-down 440w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/01\/hpanel-databases-management-sidebar.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2022\/01\/hpanel-databases-management-sidebar.png\/w=150,fit=scale-down 150w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/figure><\/div><p>Since we already located the <strong>remote MySQL hostname <\/strong>in the previous step, we will only need the&nbsp;<strong>MySQL Database<\/strong> and <strong>MySQL User<\/strong>.<\/p><p>That&rsquo;s all! We now have all we need to start configuring the HeidiSQL client.<\/p><h2 class=\"wp-block-heading\" id=\"h-step-3-configuring-heidisql-client\">Step 3 &ndash; Configuring HeidiSQL client<\/h2><p>Open the database client and press <strong>New <\/strong>to create an entry.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/new-connection-in-heidisql-client.png\"><img loading=\"lazy\" decoding=\"async\" width=\"686\" height=\"41\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/new-connection-in-heidisql-client.png\/public\" alt=\"Making a new connection in HeidiSQL client\" class=\"wp-image-8313\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/new-connection-in-heidisql-client.png\/w=686,fit=scale-down 686w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/new-connection-in-heidisql-client.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/new-connection-in-heidisql-client.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/a><\/figure><\/div><p>Then, you will need to name the entry and fill in the MySQL database configuration.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-completed-db-configuration.png\"><img loading=\"lazy\" decoding=\"async\" width=\"679\" height=\"408\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-completed-db-configuration.png\/public\" alt=\"Filling MySQL database details in HeidiSQL configuration screen\" class=\"wp-image-8314\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-completed-db-configuration.png\/w=679,fit=scale-down 679w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-completed-db-configuration.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-completed-db-configuration.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/a><\/figure><\/div><p>Make sure to complete the following fields:<\/p><ul class=\"wp-block-list\">\n<li>Network Type &ndash; set it to <strong>MySQL (TCP\/IP).<\/strong><\/li>\n\n\n\n<li>Hostname \/ IP &ndash; enter the <strong>remote MySQL hostname<\/strong> located in step 1 of this tutorial.<\/li>\n\n\n\n<li>User &ndash; Enter the MySQL database user located in step 2.<\/li>\n\n\n\n<li>Password &ndash; Fill in the user password.<\/li>\n\n\n\n<li>Port &ndash; The default MySQL port for local and remote connections is <strong>3306<\/strong>.<\/li>\n\n\n\n<li>Databases &ndash; Input the MySQL database name found in step 2.<\/li>\n<\/ul><p>Once done, press the <strong>Open <\/strong>button and you&rsquo;ll be inside your database.<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"412\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\/public\" alt=\"Successful connection to a database using HeidiSQL\" class=\"wp-image-8315\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\/w=846,fit=scale-down 846w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-client-connection-success.png\/w=768,fit=scale-down 768w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/a><\/figure><\/div><p>Congratulations! You can now access your databases remotely using a HeidiSQL client.<\/p><h2 class=\"wp-block-heading\" id=\"h-troubleshooting-common-heidisql-connection-errors\">Troubleshooting common HeidiSQL connection errors<\/h2><p>Sometimes mistakes or mistypes happen that can cause HeidiSQL client to show errors. Let&rsquo;s discuss a few common ones and see how we can fix them.<\/p><h3 class=\"wp-block-heading\" id=\"h-can-t-connect-to-mysql-server\">Can&rsquo;t connect to MySQL server<\/h3><p>The error occurs when using an incorrect MySQL port. It usually looks like this:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-cant-connect-to-mysql-server.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"164\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-cant-connect-to-mysql-server.png\/public\" alt=\"Can't connect to MySQL server on 10060 error in HeidiSQL\" class=\"wp-image-8331\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-cant-connect-to-mysql-server.png\/w=362,fit=scale-down 362w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-cant-connect-to-mysql-server.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-cant-connect-to-mysql-server.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><\/figure><\/div><p>To fix it, review the port number in your HeidiSQL configuration. On Hostinger, this value is <strong>3306<\/strong>.&nbsp;You may also contact your hosting provider as this value can differ.<\/p><h3 class=\"wp-block-heading\" id=\"h-unknown-mysql-server-host\">Unknown MySQL server host<\/h3><p>The following error can happen due to incorrect MySQL hostname. It&rsquo;s displayed as:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-unknown-mysql-server-host.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"164\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-unknown-mysql-server-host.png\/public\" alt=\"Unknown MySQL server host error in HeidiSQL\" class=\"wp-image-8332\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-unknown-mysql-server-host.png\/w=362,fit=scale-down 362w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-unknown-mysql-server-host.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-unknown-mysql-server-host.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><\/figure><\/div><p>To get rid of it, double check if your remote MySQL hostname value is correct. On Hostinger, you may locate it in&nbsp;<strong>Remote MySQL&nbsp;<\/strong>section of the hosting panel.<\/p><h3 class=\"wp-block-heading\" id=\"h-access-denied-for-user\">Access denied for user<\/h3><p>This error can come in different forms and relates to incorrect details or missing IP entry in&nbsp;<strong>Remote MySQL&nbsp;<\/strong>section. Here&rsquo;s one version of it:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"179\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user.png\/public\" alt=\"Access denied for user error in HeidiSQL\" class=\"wp-image-8333\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user.png\/w=362,fit=scale-down 362w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><\/figure><\/div><p>If you see this error, try one of these 3 solutions:<\/p><ol class=\"wp-block-list\">\n<li>Double check if you added the correct IP address in&nbsp;<strong>Remote MySQL&nbsp;<\/strong>section. Start by looking up your IP address once again using any online tool. Furthermore, a dynamic IP address can cause this, as it changes after a period of time.<\/li>\n\n\n\n<li>Make sure the MySQL user is correct. You can double check it in&nbsp;<strong>MySQL Databases&nbsp;<\/strong>section.<\/li>\n\n\n\n<li>Re-check the MySQL user password. You may reset it via&nbsp;<strong>MySQL Databases<\/strong> section. Alternatively, if you are trying to reach your WordPress database, you may locate its current password in the<strong> wp-config.php<\/strong> file.<\/li>\n<\/ol><p>The error may also look like this:<\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user-to-database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"363\" height=\"179\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user-to-database.png\/public\" alt=\"Access denied for user to database error in HeidiSQL\" class=\"wp-image-8334\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user-to-database.png\/w=363,fit=scale-down 363w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user-to-database.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2018\/02\/heidisql-access-denied-for-user-to-database.png\/w=300,fit=scale-down 300w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/a><\/figure><\/div><p>This indicates that your&nbsp;database name is wrong. Re-check the name in&nbsp;<strong>MySQL Databases&nbsp;<\/strong>section and update your HeidiSQL client configuration. As a result, you should have no problem managing your database.<\/p><?xml encoding=\"utf-8\" ?><figure class=\"wp-block-image size-full\"><a class=\"hgr-tutorials-cta hgr-tutorials-cta-web-hosting\" href=\"\/ng\/web-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/11\/Web-hosting_in-text-banner.png\/public\" alt=\"Hostinger web hosting banner\" class=\"wp-image-98604\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/11\/Web-hosting_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/11\/Web-hosting_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/11\/Web-hosting_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/11\/Web-hosting_in-text-banner.png\/w=768,fit=scale-down 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><h2 class=\"wp-block-heading\" id=\"h-further-reading\">Further Reading<\/h2><p>For more MySQL basics and tutorials, check out these articles:<\/p><ul class=\"wp-block-list\">\n<li><a href=\"\/ng\/tutorials\/how-to-connect-php-to-mysql\" target=\"_blank\" rel=\"noopener noreferrer\">How to Connect PHP to MySQL Database<\/a><\/li>\n\n\n\n<li><a href=\"\/ng\/tutorials\/how-to-use-php-to-insert-data-into-mysql-database\" target=\"_blank\" rel=\"noopener noreferrer\">How to Use PHP to Insert Data Into MySQL Database<\/a><\/li>\n\n\n\n<li><a href=\"\/ng\/tutorials\/difference-between-mysql-and-sql-server\" target=\"_blank\" rel=\"noopener noreferrer\">Difference Between MySQL and SQL Server<\/a><\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"h-final-word\">Final Word<\/h2><p>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.<\/p><p>Also, do you have any questions, tips, or ideas to share? You are welcome to do so in the comments below!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/ng\/tutorials\/heidisql-remote-mysql-connection\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":145346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"HeidiSQL: How to Easily Connect to a MySQL Database","rank_math_description":"HeidiSQL allows to conveniently manage all your MySQL databases. Learn how to add all your databases created on Hostinger to HeidiSQL and manage them.","rank_math_focus_keyword":"heidisql","footnotes":""},"categories":[22644],"tags":[],"class_list":["post-8240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vps"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/como-utilizar-o-heidisql-para-se-conectar-ao-banco-de-dados-mysql","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/como-usar-heidisql-para-conectarse-a-mysql","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-menggunakan-heidisql-untuk-set-mysql","default":0},{"locale":"en-UK","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/como-usar-heidisql-para-conectarse-a-mysql","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/como-usar-heidisql-para-conectarse-a-mysql","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/como-usar-heidisql-para-conectarse-a-mysql","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/como-utilizar-o-heidisql-para-se-conectar-ao-banco-de-dados-mysql","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/heidisql-remote-mysql-connection","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/heidisql-remote-mysql-connection","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/posts\/8240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/comments?post=8240"}],"version-history":[{"count":32,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/posts\/8240\/revisions"}],"predecessor-version":[{"id":145345,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/posts\/8240\/revisions\/145345"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/media\/145346"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/media?parent=8240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/categories?post=8240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/ng\/tutorials\/wp-json\/wp\/v2\/tags?post=8240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}