mysql57 忘记密码后修改密码

Posted on Posted in mysql, 百态人生

mysql57[忘记密码][1],开启--skip-grant-tables模式后,修改密码

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

[1]: https://liuhonghe.me/mysql-forget-passwd.html

» 转载请注明来源:呢喃 » mysql57 忘记密码后修改密码

Leave a Reply

Your email address will not be published. Required fields are marked *

17 − 16 =