目录

hymn

忽有故人心头过,回首山河已是秋。

X

MySQL 更新密码

5.7之前

mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='username';

5.7

mysql> UPDATE user SET authentication_string=PASSWORD("new_password") WHERE user='root';

//刷新系统权限表
mysql> FLUSH PRIVILEGES;


标题:MySQL 更新密码
作者:hymn
地址:https://dxyhymn.com/articles/2020/07/02/1593659848647.html