Différences

Ci-dessous, les différences entre deux révisions de la page.

--- tech:mysql_mariadb_-_reset_root_pasword [2025/03/24 15:06] – créée - modification externe 127.0.0.1
+++ tech:mysql_mariadb_-_reset_root_pasword [2025/03/24 20:49] (Version actuelle) – Jean-Baptiste
@@ Ligne 1: / Ligne 1: @@
+<!DOCTYPE markdown>
+{{tag>Brouillon Mysql MDP}}
+# MySQL / MariaDB - Reset root pasword
+## Méthode 1
+~~~bash
+sudo /etc/init.d/mysql stop
+~~~
+~~~bash
+sudo mysqld_safe --skip-grant-tables &
+~~~
+~~~bash
+mysql -uroot
+~~~
+~~~sql
+use mysql;
+-- UPDATE user SET authentication_string=PASSWORD("mynewpassword") WHERE User='root';
+UPDATE user SET Password=PASSWORD("mynewpassword") WHERE User='root';
+FLUSH PRIVILEGES;
+QUIT
+~~~
+FIXME