tech:mysql_mariadb_-_reset_root_pasword
Ceci est une ancienne révision du document !
<!DOCTYPE markdown>
- 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 ~~~
tech/mysql_mariadb_-_reset_root_pasword.1742845763.txt.gz · Dernière modification : de Jean-Baptiste