{"id":2106,"date":"2022-11-02T13:42:39","date_gmt":"2022-11-02T13:42:39","guid":{"rendered":"https:\/\/blog.hostinger.io\/fr\/support\/2022\/11\/02\/4564363-comment-modifier-les-autorisations-d-un-utilisateur-de-base-de-donnees-chez-hostinger\/"},"modified":"2025-08-26T21:07:06","modified_gmt":"2025-08-26T21:07:06","slug":"4564363-comment-modifier-les-autorisations-d-un-utilisateur-de-base-de-donnees-chez-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/fr\/support\/4564363-comment-modifier-les-autorisations-d-un-utilisateur-de-base-de-donnees-chez-hostinger\/","title":{"rendered":"Comment Modifier les Autorisations d&rsquo;un Utilisateur de Base de Donn\u00e9es chez Hostinger"},"content":{"rendered":"<p class=\"no-margin\">La modification des autorisations de l&rsquo;utilisateur de la base de donn&eacute;es pourrait &ecirc;tre utile si vous souhaitez avoir des pr&eacute;f&eacute;rences personnalis&eacute;es pour certaines bases de donn&eacute;es, par exemple, pour faire une base de donn&eacute;es avec des autorisations de lecture seule. <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Pour modifier les autorisations de votre base de donn&eacute;es, allez dans <b><a href=\"https:\/\/hpanel.hostinger.com\/websites\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Sites Web<\/a><\/b> &rarr; <b>G&eacute;rer<\/b>, recherchez <b>Gestion des Bases de donn&eacute;es <\/b>dans la barre lat&eacute;rale et cliquez dessus : <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/fr\/support\/wp-content\/uploads\/sites\/56\/2022\/11\/a520d098-6784-428a-8b86-15556d93adb7.jpg\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Dans la section <b>Liste des bases de donn&eacute;es et leurs utilisateurs MySQL<\/b> actuels, cliquez sur le bouton <b>&#8942;<\/b> en face de la base de donn&eacute;es souhait&eacute;e et choisissez <b>Changer les permissions <\/b>: <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/fr\/support\/wp-content\/uploads\/sites\/56\/2022\/11\/eef6a299-7c0a-4bd0-8842-e832f8e03c5d.jpg\"><\/div><p class=\"no-margin\">Par d&eacute;faut, l&rsquo;utilisateur de MySQL a toutes les permissions accord&eacute;es. Vous pouvez r&eacute;voquer les permissions en supprimant la coche &agrave; c&ocirc;t&eacute; de la permission sp&eacute;cifique : <\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/fr\/support\/wp-content\/uploads\/sites\/56\/2022\/11\/84799e85-a3ff-4af0-807a-c0162047f95d.jpg\"><\/div><p class=\"no-margin\">Une fois que tout est pr&ecirc;t, cliquez sur <b>Mise &agrave; jour <\/b>pour appliquer les changements &#128522;<\/p><p class=\"no-margin\">\n<\/p><h4 id=\"h_f6ea69632c\">Ressources suppl&eacute;mentaires :<\/h4><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/fr\/support\/1864454-comment-gerer-les-bases-de-donnees-mysql\" target=\"_blank\" class=\"intercom-content-link\">Comment g&eacute;rer les bases de donn&eacute;es MySQL <\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Modification des autorisations pour un utilisateur de base de donn\u00e9es dans 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":[220],"tags":[],"class_list":["post-2106","post","type-post","status-publish","format-standard","hentry","category-gestion-de-base-de-donnees"],"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\/fr\/support\/wp-json\/wp\/v2\/posts\/2106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/comments?post=2106"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2106\/revisions"}],"predecessor-version":[{"id":2934,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2106\/revisions\/2934"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/media?parent=2106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/categories?post=2106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/tags?post=2106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}