{"id":1331,"date":"2019-02-08T10:36:10","date_gmt":"2019-02-08T10:36:10","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2019\/02\/08\/1864454-how-to-manage-mysql-databases-in-hostinger\/"},"modified":"2026-10-15T07:45:52","modified_gmt":"2026-10-15T07:45:52","slug":"1864454-how-to-manage-mysql-databases-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/1864454-how-to-manage-mysql-databases-in-hostinger\/","title":{"rendered":"How to manage MySQL databases in Hostinger"},"content":{"rendered":"<p class=\"no-margin\">MySQL databases can be managed within the Databases section under the <a data-click-id=\"hgr-post-content-link-website-section-of-hostinger-dashboard\" href=\"https:\/\/www.hostinger.com\/support\/6501982-how-to-use-the-websites-section-in-hostinger\/\">Website section of Hostinger dashboard<\/a>. This is where you view, create, and configure the databases used by your MySQL, an open-source relational database management system &mdash; see <a data-click-id=\"hgr-post-content-link-which-database-management-system-is-used-at-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583226-which-database-management-system-is-used-at-hostinger\/\">which database management system is used at Hostinger<\/a> for more on how it works.<\/p><h2 id=\"h-access-the-databases-section\">Access the Databases section<\/h2><p class=\"no-margin\">To access it, go to <b><a data-click-id=\"hgr-post-content-link-websites\" class=\"intercom-content-link\" href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" rel=\"noopener\">Websites<\/a> &rarr; <a data-click-id=\"hgr-post-content-link-dashboard\" href=\"https:\/\/www.hostinger.com\/support\/6627955-how-to-use-the-hosting-dashboard-in-hostinger\/\">Dashboard<\/a><\/b>, search for <b>Databases<\/b> <b>Management<\/b> on the sidebar and click on it:<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/16aef951-5279-45de-a45b-f86081631e55.jpg\" alt=\"Hostinger hPanel Databases menu with Management option highlighted\" data-media-id=\"5016\"><\/div><p class=\"no-margin\">Once there, you can <b>choose a website<\/b> from the left drop-down menu to show its associated databases:<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20689\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42.png\" alt=\"\" width=\"1156\" height=\"454\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42.png 1156w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42-300x118.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42-1024x402.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42-768x302.png 768w\" sizes=\"(max-width: 1156px) 100vw, 1156px\" \/><\/div><div>\n<h2 id=\"h-view-and-assign-databases\">View and assign databases<\/h2>\n<p>You will be presented with the <b>List of Current MySQL Databases And Users <\/b>section. Please note that all new databases will be assigned to the selected domain; if a database is not yet assigned to a website, you can do so by clicking on <b>Assign<\/b>:<\/p>\n<\/div><div class=\"intercom-container\"><img decoding=\"async\" class=\"alignnone wp-image-20690 size-full\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42_1-e1792050303396.png\" alt=\"\" width=\"1150\" height=\"593\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42_1-e1792050303396.png 1150w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42_1-e1792050303396-300x155.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42_1-e1792050303396-1024x528.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-42_1-e1792050303396-768x396.png 768w\" sizes=\"(max-width: 1150px) 100vw, 1150px\" \/><\/div><div>To find the connection details for a specific database (such as its host, username, or database name), see <a data-click-id=\"hgr-post-content-link-how-to-find-your-mysql-database-details-in-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583552-how-to-find-your-mysql-database-details-in-hostinger\/\">how to find your MySQL database details in Hostinger<\/a>.<\/div><div><\/div><div>\n<div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">If you don&rsquo;t have a database yet, see <a data-click-id=\"hgr-post-content-link-how-to-create-a-new-mysql-database-in-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583542-how-to-create-a-new-mysql-database-in-hostinger\/\">how to create a new MySQL database in Hostinger<\/a> first.<\/div>\n<\/div><h2 id=\"h-access-your-database-via-phpmyadmin\">Access your database via phpMyAdmin<\/h2><p class=\"no-margin\">To access your database contents via phpMyAdmin, click on <b>Enter phpMyAdmin<\/b>:<\/p><div class=\"intercom-container\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20691\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43.png\" alt=\"\" width=\"1170\" height=\"408\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43.png 1170w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43-300x105.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43-1024x357.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43-768x268.png 768w\" sizes=\"(max-width: 1170px) 100vw, 1170px\" \/><\/div><div>\n<div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">See <a data-click-id=\"hgr-post-content-link-how-to-access-phpmyadmin-at-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583545-how-to-access-phpmyadmin-at-hostinger\/\">how to access phpMyAdmin at Hostinger<\/a> for more on using this tool. If you need to connect to your database from an external application instead, see <a data-click-id=\"hgr-post-content-link-how-to-set-up-remote-mysql-access-in-hostinger\" href=\"https:\/\/www.hostinger.com\/support\/1583546-how-to-set-up-remote-mysql-access-in-hostinger\/\">how to set up remote MySQL access in Hostinger<\/a>.<\/div>\n<\/div><h2 id=\"h-manage-a-database\">Manage a database<\/h2><p class=\"no-margin\">If you need more options, select your desired database and click the <b>&#8942; <\/b>button:<\/p><div class=\"intercom-container\"><img decoding=\"async\" class=\"alignnone size-full wp-image-20692\" src=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43_1.png\" alt=\"\" width=\"1203\" height=\"459\" srcset=\"https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43_1.png 1203w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43_1-300x114.png 300w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43_1-1024x391.png 1024w, https:\/\/www.hostinger.com\/support\/wp-content\/uploads\/sites\/55\/2026\/10\/2026-10-15_14-43_1-768x293.png 768w\" sizes=\"(max-width: 1203px) 100vw, 1203px\" \/><\/div><p class=\"no-margin\">You will be able to do the following actions:<\/p><ol>\n<li>\n<p class=\"no-margin\"><b>Repair the database<\/b> &ndash; it will analyze and optimize your database tables, ensuring that the database is working perfectly fine<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Change the <b><a data-click-id=\"hgr-post-content-link-current-database-password\" class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/1583522-how-to-change-a-database-password-in-hostinger\/\" target=\"_blank\" rel=\"noopener\">current database password<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Change <b><a data-click-id=\"hgr-post-content-link-various-permissions\" class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/4564363-how-to-change-permissions-for-a-database-user-in-hostinger\/\" target=\"_blank\" rel=\"noopener\">various permissions<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a data-click-id=\"hgr-post-content-link-delete\" class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/1583544-how-to-delete-a-database-in-hostinger\/\" target=\"_blank\" rel=\"noopener\">Delete<\/a><\/b> the database completely<\/p>\n<\/li>\n<\/ol><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">If you&rsquo;re running out of space, see <a data-click-id=\"hgr-post-content-link-what-to-do-if-the-database-size-limit-has-been-reached\" href=\"https:\/\/www.hostinger.com\/support\/5534251-what-to-do-if-the-database-size-limit-has-been-reached-in-hostinger\/\">what to do if the database size limit has been reached.<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Managing MySQL databases via Hostinger dashboard<\/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":[245],"tags":[],"class_list":["post-1331","post","type-post","status-publish","format-standard","hentry","category-database-management"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1864454-how-to-manage-mysql-databases-in-hostinger","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1864454-como-administrar-bases-de-datos-mysql-en-hostinger","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/1864454-comment-gerer-les-bases-de-donnees-mysql-chez-hostinger","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1864454-cara-mengelola-database-mysql-di-hostinger","default":0},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/support\/1864454-como-gerenciar-bancos-de-dados-mysql-na-hostinger","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/1864454-\u044f\u043a-\u043a\u0435\u0440\u0443\u0432\u0430\u0442\u0438-\u0431\u0430\u0437\u0430\u043c\u0438-\u0434\u0430\u043d\u0438\u0445-mysql-\u043d\u0430-hostinger","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1331","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=1331"}],"version-history":[{"count":7,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1331\/revisions"}],"predecessor-version":[{"id":14359,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1331\/revisions\/14359"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1331"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1331"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}