mysql5.7安装细节
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;(可选)
相关推荐
lpfvip00 2020-10-07
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11