mysql 5.7 root忘记密码 转

代码语言：javascript复制

service mysqld stop

代码语言：javascript复制

mysqld_safe --skip-grant-tables &

 update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';

代码语言：javascript复制

service mysql restart

代码语言：javascript复制

set password for 'root'@'localhost'=password('123');

注意密码强度

(adsbygoogle = window.adsbygoogle || []).push({});

authentication host localhost root set

0 人点赞