{"id":2068,"date":"2022-07-26T03:52:10","date_gmt":"2022-07-26T03:52:10","guid":{"rendered":"https:\/\/blog.hostinger.io\/pt\/support\/2022\/07\/26\/4564363-como-alterar-as-permissoes-do-usuario-do-banco-de-dados-na-hostinger\/"},"modified":"2025-08-27T06:26:23","modified_gmt":"2025-08-27T06:26:23","slug":"4564363-como-alterar-as-permissoes-do-usuario-do-banco-de-dados-na-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/br\/support\/4564363-como-alterar-as-permissoes-do-usuario-do-banco-de-dados-na-hostinger\/","title":{"rendered":"Como Alterar as Permiss\u00f5es do Usu\u00e1rio do Banco de Dados na Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Alterar as permiss&otilde;es do usu&aacute;rio do banco de dados pode ser &uacute;til se voc&ecirc; quiser personalizar suas prefer&ecirc;ncias, como criar um banco de dados com permiss&otilde;es somente para leitura, por exemplo.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Para alterar as permiss&otilde;es do seu banco de dados, v&aacute; para <b><a href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Sites<\/a>&nbsp;<\/b>&rarr; <b>Gerenciar<\/b>, encontre <b>Bancos de dados MySQL<\/b> na barra lateral esquerda e clique nele: <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/br\/support\/wp-content\/uploads\/sites\/59\/2022\/07\/d1e02f8d-6409-4aa7-ae34-24f9a48dcd07.jpg\"><\/div><p class=\"no-margin\">Na se&ccedil;&atilde;o <b>Lista de Usu&aacute;rios e Bancos de Dados Atuais<\/b>, clique nos tr&ecirc;s pontinhos (&#8942;) na frente do banco de dados desejado e escolha <b>Alterar Permiss&otilde;es<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/br\/support\/wp-content\/uploads\/sites\/59\/2022\/07\/c0c63b3b-5ae0-4c6f-b797-d33ff56edfa7.jpg\"><\/div><p class=\"no-margin\">Por padr&atilde;o, o usu&aacute;rio MySQL tem todas as permiss&otilde;es concedidas. Voc&ecirc; pode retirar as permiss&otilde;es removendo um &#10004;&#65039; pr&oacute;ximo &agrave; permiss&atilde;o espec&iacute;fica, como na imagem:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/br\/support\/wp-content\/uploads\/sites\/59\/2022\/07\/cfe3c273-3c2e-4fac-9940-144c4d93a204.jpg\"><\/div><p class=\"no-margin\">Quando tudo estiver pronto, clique em <b>Atualizar<\/b> para aplicar as altera&ccedil;&otilde;es &#128522;<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>Recursos adicionais:<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/br\/support\/1864454-como-gerenciar-bancos-de-dados-mysql\" target=\"_blank\" class=\"intercom-content-link\">Como gerenciar bancos de dados MySQL<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Aprenda a alterar as permiss\u00f5es de um usu\u00e1rio de banco de dados pelo 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":[222],"tags":[],"class_list":["post-2068","post","type-post","status-publish","format-standard","hentry","category-gerenciamento-de-banco-de-dados"],"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\/br\/support\/wp-json\/wp\/v2\/posts\/2068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/comments?post=2068"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts\/2068\/revisions"}],"predecessor-version":[{"id":4799,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/posts\/2068\/revisions\/4799"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/media?parent=2068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/categories?post=2068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/br\/support\/wp-json\/wp\/v2\/tags?post=2068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}