{"id":1112,"date":"2018-07-21T18:04:47","date_gmt":"2018-07-21T16:04:47","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&#038;p=1112"},"modified":"2020-02-11T15:52:17","modified_gmt":"2020-02-11T14:52:17","slug":"plesk-modifier-le-mot-de-passe-de-ma-base-de-donnees-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/plesk-modifier-le-mot-de-passe-de-ma-base-de-donnees-mysql\/","title":{"rendered":"Plesk: Change the password for my MySQL database"},"content":{"rendered":"<p>In this guide we will see how to change the password of a MySQL database from the Plesk interface.<\/p>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon\"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Note<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tThis guide is dedicated only to our subscribers who have subscribed to the old <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/upgrade-mon-hebergement-mutualise\/\">shared hosting<\/a> Plesk (SMART, DISCOUNT, PRO and SECURE offer).    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<h2>CMS<\/h2>\n<p>If you have installed a CMS (such as WordPress \/ Drupal \/ Joomla \/ prestashop \/ other), it is not recommended to change the password or the username of the database because it will break your whole site and will display instead of the homepage an error message indicating that access to the database can not be established.<\/p>\n<h2>Plesk Access<\/h2>\n<p>The first thing to do is to go to <a href=\"https:\/\/cp.magic.fr\/\">your client interface<\/a>\u00a0which you can find the link to on our showcase site. Once there, click on Plesk &gt; My Plesk (Manage my subscription) &gt; menu\u00a0<strong>Databases<\/strong>.<\/p>\n<h2>Change the password<\/h2>\n<p>You can either click on the link\u00a0<strong>User management<\/strong>\u00a0then the user name in question. Or click directly on the username of the database.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-569\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1.jpg\" alt=\"Change the database password\" width=\"1203\" height=\"330\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1.jpg 1203w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-300x82.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-768x211.jpg 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-1024x281.jpg 1024w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-50x14.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-60x16.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-1-100x27.jpg 100w\" sizes=\"(max-width: 1203px) 100vw, 1203px\" \/><\/p>\n<p>The interface gives you a hand not only to change the password, but also the username. You can use the\u00a0<strong>Generate<\/strong>\u00a0and\u00a0<strong>View<\/strong>\u00a0to have the system help you set up a strong and secure password.<\/p>\n<p>Validate via the button\u00a0<strong>OK\u00a0<\/strong>for the modification to be taken into account.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-570\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2.jpg\" alt=\"Password change\" width=\"706\" height=\"523\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2.jpg 706w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2-300x222.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2-50x37.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2-60x44.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Modifier-le-mot-de-passe-de-base-de-donnes-2-100x74.jpg 100w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>In this guide, we will see how to change the password of a MySQL database from the Plesk interface. CMS If you have installed a CMS (such as WordPress \/ Drupal \/ Joomla \/ prestashop \/ other), it is not recommended to change the password or the username of the database.<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[728],"ht-kb-tag":[],"class_list":["post-1112","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-serveur-plesk"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/1112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=1112"}],"version-history":[{"count":0,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/1112\/revisions"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=1112"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=1112"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}