{"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":"2025-08-27T07:12:58","modified_gmt":"2025-08-27T07:12:58","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 <b>Databases<\/b> section of <b>hPanel<\/b>. To access it, go to <b><a href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Websites<\/a> &rarr; Dashboard<\/b>, search for <b>Databases<\/b> <b>Management<\/b> on the sidebar and click on it:<\/p><p class=\"no-margin\">\n<\/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\"><\/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><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/5478768c-636f-47f7-b373-264cd9946b26.jpg\"><\/div><p class=\"no-margin\">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><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/b7b955ed-7310-4295-819a-7b176ee15424.jpg\"><\/div><p class=\"no-margin\">To access your database contents via phpMyAdmin, click on <b>Enter phpMyAdmin<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/0e08c67d-c8e8-4bf7-85a7-bad02b25d704.jpg\"><\/div><p class=\"no-margin\">If you need more options, select your desired database and click the <b>&#8942; <\/b>button:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2019\/02\/d4d0b822-7e47-43d1-968f-7bf9e18d37e2.jpg\"><\/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 href=\"\/support\/1583522-how-can-i-recover-mysql-password\" target=\"_blank\" class=\"intercom-content-link\">current database password<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Change <b><a href=\"\/support\/4564363-how-can-i-change-permissions-of-the-database-user\" target=\"_blank\" class=\"intercom-content-link\">various permissions<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/support\/1583544-how-can-i-delete-my-mysql-database\" target=\"_blank\" class=\"intercom-content-link\">Delete<\/a><\/b> the database completely<\/p>\n<\/li>\n<\/ol><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>Additional resources<\/b>: <\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/support\/1583542-how-can-i-create-a-new-mysql-database\" target=\"_blank\" class=\"intercom-content-link\">How to Create a New MySQL Database<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Managing MySQL databases via Hostinger\u2019s hPanel<\/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-PT","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-----mysql--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":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1331\/revisions"}],"predecessor-version":[{"id":5025,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1331\/revisions\/5025"}],"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}]}}