{"id":1424,"date":"2019-02-08T10:36:02","date_gmt":"2019-02-08T10:36:02","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1583546-how-to-set-up-remote-mysql-access-in-hostinger\/"},"modified":"2026-05-08T13:02:54","modified_gmt":"2026-05-08T13:02:54","slug":"1583546-how-to-set-up-remote-mysql-access-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1583546-how-to-set-up-remote-mysql-access-in-hostinger\/","title":{"rendered":"How to Set Up Remote MySQL Access in Hostinger"},"content":{"rendered":"<p class=\"no-margin\">The <b>Remote MySQL<\/b> feature access allows remote hosts (servers) to manage your databases. To set it up, first, you need to allow the desired remote IP to connect to your database. This can be done by accessing <b><a class=\"intercom-content-link\" href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" rel=\"noopener\">Websites<\/a>&nbsp;<\/b>&rarr; <b>Dashboard, <\/b>searching for <b>Remote MySQL<\/b> on the left sidebar, and clicking on it:<br>\n&#8203;<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/23634c68-8fd3-4de0-bbb4-c75cb2bfe4c2.jpg\" alt=\"Hostinger control panel menu showing the highlighted Remote MySQL option under Databases\" data-media-id=\"5128\"><\/div><p class=\"no-margin\">In the newly opened window, you will be able to create the new connection by filling in the details:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b>IP (IPv4 or IPv6)<\/b> &ndash; the IP address from which the remote connection will be initiated<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Any Host &ndash; <\/b>click this checkbox to allow the connection from any IP. This will add a % symbol in the IP field<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Database<\/b> &ndash; select the database which will be remotely accessed<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">When all is good to go, click on <b>Create<\/b>:<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/0c951b1e-10d2-42ac-a232-9929e9c80767.jpg\" data-media-id=\"5129\" alt=\"Hostinger Remote MySQL page showing Any Host checkbox, database dropdown, and Create button\"><\/div><p class=\"no-margin\">You can find the MySQL server hostname on top of the <b>Create remote database connection <\/b>section:<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/628d2069-ece4-4577-acfe-5f8587bcf715.jpg\" alt=\"Hostinger MySQL setup showing server hostname and IP for remote database connection\" data-media-id=\"5131\"><\/div><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">\n<p class=\"no-margin\">The default port for remote connections is <b><a class=\"intercom-content-link\" href=\"\/support\/1583223-what-mysql-port-is-used-at-hostinger\" target=\"_blank\" rel=\"noopener\">3306<\/a><\/b> &#128161;<\/p>\n<\/div><p class=\"no-margin\">After the remote access is created, you will be able to remove it if needed on the <b>Remote MySQL <\/b>section:<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/2e3c8384-6fba-4590-8760-342be758c08c.jpg\" data-media-id=\"5132\" alt=\"Hostinger Remote MySQL table showing database u123456789_database with access host % and delete action button\"><\/div><p class=\"no-margin\">That&rsquo;s it! Now you know how to set up and manage remote access to your databases &#128522;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setting up a remote MySQL connection for your databases at Hostinger<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[242],"tags":[],"class_list":["post-1424","post","type-post","status-publish","format-standard","hentry","category-remote-mysql-connection"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1583546-how-to-set-up-remote-mysql-access-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1583546-como-configurar-una-conexion-remota-de-mysql-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/1583546-comment-configurer-un-acces-mysql-a-distance-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1583546-cara-setup-akses-remote-mysql-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1583546-como-configurar-o-acesso-remoto-ao-mysql-no-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/1583546------m\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1424"}],"version-history":[{"count":2,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1424\/revisions"}],"predecessor-version":[{"id":7025,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1424\/revisions\/7025"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}