{"id":1171,"date":"2020-10-23T15:44:44","date_gmt":"2020-10-23T15:44:44","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/10\/23\/4564363-how-to-change-permissions-for-a-database-user-in-hostinger\/"},"modified":"2025-08-27T07:09:33","modified_gmt":"2025-08-27T07:09:33","slug":"4564363-how-to-change-permissions-for-a-database-user-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4564363-how-to-change-permissions-for-a-database-user-in-hostinger\/","title":{"rendered":"How to Change Permissions for a Database User in Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Changing the permissions of the database user might be useful if you want to have custom preferences for some databases, for example, to make a database with read-only permissions. <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">To change your database&rsquo;s permissions, go to <b><a href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Websites<\/a>&nbsp;<\/b>&rarr; <b>Manage<\/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\/2020\/10\/522a0820-6ab0-44ef-bada-8036a9fb5f45.jpg\"><\/div><p class=\"no-margin\">In the section <b>List of Current MySQL Databases And Users, <\/b>click on <b>&#8942; <\/b>button in front of the desired database and choose <b>Change Permissions<\/b>: <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/396d345a-d477-4dcd-bd0b-b5af3410921a.jpg\"><\/div><p class=\"no-margin\">By default, MySQL user has all the permissions granted. You can revoke permissions by removing the checkmark next to the specific permission: <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/4a9c15ab-4e16-4ee6-9630-2a4b23760aa1.jpg\"><\/div><p class=\"no-margin\">Once everything is ready, click on <b>Update<\/b> to apply the changes &#128522; <\/p><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\/1864454-how-to-manage-mysql-databases\" target=\"_blank\" class=\"intercom-content-link\">How to manage MySQL databases<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Changing permissions for a database user in 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-1171","post","type-post","status-publish","format-standard","hentry","category-database-management"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4564363-how-to-change-permissions-for-a-database-user-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4564363-como-cambiar-los-permisos-de-un-usuario-de-la-base-de-datos-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4564363-comment-modifier-les-autorisations-d-un-utilisateur-de-base-de-donnees-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4564363-bagaimana-cara-mengubah-permission-atau-hak-akses-user-database-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4564363-como-alterar-as-permissoes-do-usuario-do-banco-de-dados-na-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4564363-----\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1171","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=1171"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1171\/revisions"}],"predecessor-version":[{"id":4608,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1171\/revisions\/4608"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}