MySQL root密码忘记后更优雅的解决方法

MySQL root密码忘记后更优雅的解决方法

https://www.jb51.net/article/143453.htm

/usr/bin/mysqld_safe --defaults-file=my.cnf --skip-grant-tables --skip-networking &
/usr/bin/mysql -S /var/lib/mysql/mysql.sock
update mysql.user set password=password('123456') where host='localhost' and user='root';
flush privileges;
update user set password=password('xinmima') where user='root';

原文地址:https://www.cnblogs.com/andylhc/p/9816365.html