MySQL修改默认密码

一.MySQL 5.7版本

1.查看默认密码

shell> grep 'temporary password' /var/log/mysqld.log

2.设置新密码

mysql> SET PASSWORD = PASSWORD('your new password');

3.密码永不过期

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

4.刷新权限

mysql> flush privileges;

二.MySQL 8.0版本

1.设置新密码

mysql> ALTER USER "root"@"localhost" IDENTIFIED  BY "your new password";

2.刷新权限

mysql> flush privileges;