mysql5.7安装后查看密码并重置

1、查看密码 
grep "password" /var/log/mysqld.log

2、进入数据库,输入密码

mysql -u root -p 

密码为:

(Qpe:Gjrr82y

3、设置简单密码为123456

 set global validate_password_policy=0;
 set global validate_password_length=1;

 alter user 'root'@'localhost' identified by '123456';

 flush privileges;

 

posted @ 2020-08-28 17:39  宝英姐姐  阅读(675)  评论(0编辑  收藏  举报