{"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-08-10T05:05:02","modified_gmt":"2026-08-10T05:05:02","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>Set up remote MySQL access in Hostinger to let remote hosts connect to and manage your databases.<\/p><h3>Before you start<\/h3><ul>\n<li>If you don&rsquo;t have a database yet, see <a href=\"https:\/\/www.hostinger.com\/support\/1583542-how-to-create-a-new-mysql-database-in-hostinger\/\">how to create MySQL database<\/a> and <a href=\"https:\/\/www.hostinger.com\/support\/1864454-how-to-manage-mysql-databases-in-hostinger\/\">how to manage MySQL databases in Hostinger.<\/a><\/li>\n<\/ul><h2 id=\"h-allow-a-remote-connection\">Allow a remote connection<\/h2><p class=\"no-margin\">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\" class=\"alignnone size-full wp-image-14966\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-03_1.png\" alt=\"\" width=\"1160\" height=\"491\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-03_1.png 1160w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-03_1-300x127.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-03_1-1024x433.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-03_1-768x325.png 768w\" sizes=\"(max-width: 1160px) 100vw, 1160px\" \/><\/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\" class=\"alignnone size-full wp-image-14967\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04.png\" alt=\"\" width=\"1138\" height=\"214\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04.png 1138w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04-300x56.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04-1024x193.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04-768x144.png 768w\" sizes=\"(max-width: 1138px) 100vw, 1138px\" \/><\/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=\"https:\/\/www.hostinger.com\/support\/1583226-which-database-management-system-is-used-at-hostinger\/#h-what-mysql-port-is-used-at-hostinger\" target=\"_blank\" rel=\"noopener\">3306.<\/a><\/b><\/p>\n<\/div><p>If you need to connect to a Microsoft SQL Server database instead of MySQL, see <a href=\"https:\/\/www.hostinger.com\/support\/8583784-how-to-connect-to-the-microsoft-sql-server-odbc-at-hostinger\/\">how to connect to the Microsoft SQL Server ODBC at Hostinger.<\/a><\/p><h2 id=\"h-manage-remote-access\">Manage remote access<\/h2><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\" class=\"alignnone size-full wp-image-14968\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04_1.png\" alt=\"\" width=\"1116\" height=\"178\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04_1.png 1116w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04_1-300x48.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04_1-1024x163.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/08\/2026-08-10_12-04_1-768x122.png 768w\" sizes=\"(max-width: 1116px) 100vw, 1116px\" \/><\/div><p class=\"no-margin\">That&rsquo;s it! Now you know how to set up and manage remote access to your databases.<\/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-BR","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":4,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1424\/revisions"}],"predecessor-version":[{"id":14969,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1424\/revisions\/14969"}],"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}]}}