mysql5.7安装细节

azhou 2019-12-02

1.mysql官方yum源安装的mysql启动之后获取初始密码

  cat /var/log/mysqld.log | grep password

2.命令进入mysql

  mysql -u root -p  password

3.修改密码约束规则

<span><span><span><span> show variables like ‘validate_password%‘;</span></span></span></span>

    set global validate_password_policy=0;

4.修改密码

 set password = password(‘your new password‘);

 alter user ‘root‘@‘localhost‘ password expire never;(可选)

 flush privileges;(可选)

相关推荐