{{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