查看初始密码:
grep 'temporary password' /var/log/mysqld.log
修改初始密码:
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
如修改不了,可修改密码策略:
set global validate_password.policy=0; #设置为弱口令 set global validate_password.length=1; #密码最小长度为1
开启远程访问权限
use mysql;
select host,user from user;
update user set host = '%' where user = 'root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;