mysql-5.7密码

Fri May 31, 2019

100 Words|Read in about 1 Min
Tags: Devops   Mysql  

mysql5.7后,默认会初始化一个随机密码在日志文件中。

1.默认随机密码会过期,提示如下

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决办法:

2.SET PASSWORD = PASSWORD(‘your new password‘);

3. ALTER USER ‘root’@’localhost’ PASSWORD EXPIRE NEVER;

4.flush privileges;

See Also

Fri May 31, 2019

100 Words|Read in about 1 Min
Tags: Devops   Mysql