{"id":22,"date":"2020-06-21T21:52:01","date_gmt":"2020-06-21T21:52:01","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=22"},"modified":"2022-07-18T16:58:38","modified_gmt":"2022-07-18T16:58:38","slug":"comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/","title":{"rendered":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full is-style-default\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1.jpg\" alt=\"R\u00e9initialiser le passe root sur MySQL\/MariaDB\" class=\"wp-image-833\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<p>Oublier son mot de passe arrive \u00e0 tout le monde. Si vous oubliez ou perdez votre mot de passe root de base de donn\u00e9es MySQL ou MariaDB. Vous n&#8217;avez besoin que d&#8217;un acc\u00e8s SSH au serveur et d&#8217;un compte utilisateur ou d&#8217;un mot de passe root avec des privil\u00e8ges sudo pour acc\u00e9der et r\u00e9initialiser la base de donn\u00e9es.<\/p>\n\n\n\n<p>Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pr\u00e9requis<\/h2>\n\n\n\n<p>Afin de r\u00e9cup\u00e9rer votre mot de passe root MySQL \/ MariaDB, vous aurez besoin d\u2019acc\u00e8s au serveur Linux ex\u00e9cutant MySQL ou MariaDB dot\u00e9 d\u2019un utilisateur sudo.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9tape 1 &#8211; Identification de la version de base de donn\u00e9es.<\/h2>\n\n\n\n<p>La plupart des distributions Linux modernes sont livr\u00e9es avec MySQL ou MariaDB (une base de donn\u00e9es de remplacement populaire totalement compatible avec MySQL). Selon la base de donn\u00e9es utilis\u00e9e et sa version, vous devrez utiliser diff\u00e9rentes commandes pour r\u00e9cup\u00e9rer le mot de passe root.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Comment v\u00e9rifier votre version MySQL ou MariaDB&nbsp;?<\/strong><\/h3>\n\n\n\n<p>Il faut utiliser la commande suivante en ligne de commande SSH :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">mysql\u2013version<\/code><\/pre>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\"><kbd>Output:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqld Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64<\/pre>\n\n\n\n<p>Ou une sortie comme celle-ci pour MariaDB&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqlVer 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1<\/pre>\n\n\n\n<p>Notez quelle base de donn\u00e9es et quelle version vous avez, car vous allez les utiliser plus tard. Puis, vous devez arr\u00eater la base de donn\u00e9es pour pouvoir y acc\u00e9der manuellement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u00c9tape 2 &#8211; Arr\u00eat du serveur de base de donn\u00e9es<\/strong><\/h2>\n\n\n\n<p>Afin de modifier le mot de passe root, vous devez d&#8217;abord arr\u00eater le serveur de base de donn\u00e9es pr\u00e9alablement.<\/p>\n\n\n\n<p>Vous pouvez le faire pour MySQL avec cette commande :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl stop mysql<\/code><\/pre>\n\n\n\n<p>Et pour MariaDB avec&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl stop mariadb<\/code><\/pre>\n\n\n\n<p>Une fois le serveur de base de donn\u00e9es arr\u00eat\u00e9, vous y acc\u00e9derez manuellement pour r\u00e9initialiser le mot de passe root.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9tape 3 \u2014 Red\u00e9marrage du serveur de base de donn\u00e9es<\/h2>\n\n\n\n<p>Si vous ex\u00e9cutez MySQL et MariaDB sans charger d&#8217;informations concernant les privil\u00e8ges utilisateurs, ce qui vous permettra d&#8217;acc\u00e9der \u00e0 la ligne de commande de la base de donn\u00e9es avec les privil\u00e8ges root sans fournir le mot de passe. Cela vous permettra d&#8217;acc\u00e9der \u00e0 la base de donn\u00e9es sans le savoir.<\/p>\n\n\n\n<p>Pour ex\u00e9cuter cette op\u00e9ration, vous devez emp\u00eacher la base de donn\u00e9es de charger les tables de droits contenant les informations de privil\u00e8ge utilisateur. Pour des raisons de s\u00e9curit\u00e9 et les risques, vous devez \u00e9galement ignorer la mise en r\u00e9seau afin d\u2019emp\u00eacher d&#8217;autres clients de se connecter.<\/p>\n\n\n\n<p>D\u00e9marrez la base de donn\u00e9es sans chargement les tables de droits ni activer la mise en r\u00e9seau avec cette commande :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo mysqld_safe --skip-grant-tables --skip-networking &amp;<\/code><\/pre>\n\n\n\n<p>Le caract\u00e8re (&amp;)&nbsp; \u00e0 la fin de cette commande fera ex\u00e9cuter ce processus en arri\u00e8re-plan afin que vous puissiez continuer \u00e0 utiliser votre terminal.<\/p>\n\n\n\n<p>Vous pouvez maintenant vous connecter \u00e0 la base de donn\u00e9es en tant qu&#8217;utilisateur root, qui ne demande pas de mot de passe.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root<\/code><\/pre>\n\n\n\n<p>Vous verrez imm\u00e9diatement une invite de shell de base de donn\u00e9es.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\nMariaDB [(none)]&gt;<\/pre>\n\n\n\n<p>MariaDB :<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tapez \u00abaide\u00bb; ou '\\ h' pour obtenir de l'aide. Tapez \u00ab\\ c\u00bb pour effacer l'instruction d'entr\u00e9e actuelle.\nMariaDB [(aucun)]&gt;<\/pre>\n\n\n\n<div class=\"wp-block-group is-layout-flow\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9tape 4 &#8211; Modification du mot de passe root<\/h2>\n\n\n\n<p>Une fa\u00e7on simple de changement du mot de passe root pour les versions r\u00e9centes de MySQL est d&#8217;utiliser la commande ALTER USER. Cependant, cette commande ne fonctionnera pas vu que les tables de droits d&#8217;acc\u00e8s ne sont pas charg\u00e9es.<\/p>\n\n\n\n<p id=\"block-ba259a3d-349b-42a0-bbc2-83d786166df1\">Demandons au serveur de base de donn\u00e9es de recharger les tables de droits en ex\u00e9cutant la commande<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; FLUSH PRIVILEGES.<\/code><\/pre>\n\n\n\n<p>Maintenant, nous pouvons changer le mot de passe root.<\/p>\n\n\n\n<p>Pour <kbd>MySQL 5.7.6<\/kbd>&nbsp;plus r\u00e9cent ainsi que MariaDB 10.1.20 et plus r\u00e9cent, utilisez la commande suivante.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; ALTER USER 'root' @ 'localhost' IDENTIFIED BY 'new_password';<\/code><\/pre>\n\n\n\n<p>Pour <kbd>MySQL 5.7.5<\/kbd> et versions anciennes ainsi que MariaDB 10.1.20 et versions anciennes, utilisez:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ('new_password');<\/code><\/pre>\n\n\n\n<p>Assurez-vous de remplacer <kbd>new_password<\/kbd> par le nouveau mot de passe de votre choix<\/p>\n\n\n\n<p><strong>Remarque&nbsp;:<\/strong><\/p>\n\n\n\n<p>Si la commande ALTER UTILISATEUR ne fonctionne pas, cela signifie un dysfonctionnement. Cependant, vous pouvez essayer UPDATE &#8230; TAPER pour r\u00e9initialiser le mot de passe root.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root' AND Host = 'localhost';<\/code><\/pre>\n\n\n\n<p>Post\u00e9rieurement, N&#8217;oubliez pas de recharger les tables de droits.<\/p>\n\n\n\n<p>Dans les deux cas, vous devriez voir la confirmation montrant que&nbsp; la commande a \u00e9t\u00e9 ex\u00e9cut\u00e9e avec succ\u00e8s.<\/p>\n\n\n\n<h5 class=\"has-text-align-center wp-block-heading\"><kbd>Output&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-preformatted\">Query OK, 0 rows affected (0.00 sec)<\/pre>\n\n\n\n<p>Le mot de passe a \u00e9t\u00e9 modifi\u00e9, vous pouvez donc arr\u00eater l&#8217;instance manuelle du serveur de base de donn\u00e9es et le red\u00e9marrer comme il l&#8217;\u00e9tait auparavant.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9tape 5 \u2014 Red\u00e9marrer le serveur de base de donn\u00e9es<\/h2>\n\n\n\n<p>Premi\u00e8rement, arr\u00eatez l&#8217;instance du serveur de base de donn\u00e9es que vous avez d\u00e9marr\u00e9 manuellement \u00e0 l&#8217;\u00e9tape 3. Cette commande recherche le PID, ou l\u2019identifiant (ID) de processus, MySQL ou MariaDB, et envoie SIGTERM pour provoquer sa fin apr\u00e8s avoir effectu\u00e9 des op\u00e9rations de nettoyage. Vous pouvez en savoir plus dans ce didacticiel de gestion des processus Linux.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><kbd>Pour MySQL, utilisez&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo kill 'cat \/var\/run\/mysqld\/mysqld.pid'<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><kbd>Pour MariaDB, utilisez&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo kill '\/var\/run\/mariadb\/mariadb.pid'<\/code><\/pre>\n\n\n\n<p>Ensuite, red\u00e9marrez le service \u00e0 l&#8217;aide de systemctl.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><kbd>Pour MySQL, utilisez&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl start mysql<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\"><kbd>Pour MariaDB, utilisez&nbsp;:<\/kbd><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl start mariadb<\/code><\/pre>\n\n\n\n<p>Vous pouvez maintenant confirmer que le nouveau mot de passe a \u00e9t\u00e9 modifi\u00e9 correctement en ex\u00e9cutant&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root\u2013p<\/code><\/pre>\n\n\n\n<p>La commande devrait demander le mot de passe nouvellement attribu\u00e9. Entrez-le, et vous devriez acc\u00e9der \u00e0 l\u2019invite de la base de donn\u00e9es comme pr\u00e9vu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion. <\/h2>\n\n\n\n<p>Vous avez restaur\u00e9 le mot de passe. Assurez-vous que le nouveau mot de passe que vous choisissez est solide et s\u00e9curis\u00e9 et le garder en lieu s\u00fbr.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oublier son mot de passe arrive \u00e0 tout le monde. Si vous oubliez ou perdez votre mot de passe root de base de donn\u00e9es MySQL ou MariaDB. Vous n&#8217;avez besoin que d&#8217;un acc\u00e8s SSH au serveur et d&#8217;un compte utilisateur ou d&#8217;un mot de passe root avec des privil\u00e8ges sudo pour acc\u00e9der et r\u00e9initialiser la ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[59,31],"tags":[],"yoast_head":"\n<title>Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-21T21:52:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-18T16:58:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB\",\"datePublished\":\"2020-06-21T21:52:01+00:00\",\"dateModified\":\"2022-07-18T16:58:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\"},\"wordCount\":929,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Bases de donn\u00e9es\",\"S\u00e9curit\u00e9\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\",\"name\":\"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2020-06-21T21:52:01+00:00\",\"dateModified\":\"2022-07-18T16:58:38+00:00\",\"description\":\"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1783634435\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1783634435\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations","description":"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/","og_locale":"en_US","og_type":"article","og_title":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations","og_description":"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2020-06-21T21:52:01+00:00","article_modified_time":"2022-07-18T16:58:38+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/root_pass_mysql_fr-1.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB","datePublished":"2020-06-21T21:52:01+00:00","dateModified":"2022-07-18T16:58:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/"},"wordCount":929,"commentCount":1,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Bases de donn\u00e9es","S\u00e9curit\u00e9"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/","name":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2020-06-21T21:52:01+00:00","dateModified":"2022-07-18T16:58:38+00:00","description":"Ce guide aborde comment r\u00e9initialiser le mot de passe root de votre base de donn\u00e9es des versions tant anciennes qu\u2019aux r\u00e9centes de MySQL et MariaDB.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/comment-reinitialiser-le-mot-de-passe-root-de-la-base-de-donnees-mysql-ou-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Comment r\u00e9initialiser le mot de passe root de la base de donn\u00e9es MySQL ou MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1783634435","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1783634435","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/22"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":80,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":962,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/22\/revisions\/962"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}