查找密码并登陆mysql
    cat /var/log/mysqld.log | grep password
    image.png
    >CG8wxj9i!ri
    登录：mysql -u root -p
    image.png
    修改密码:
    set global validate_password_policy=LOW;
    set global validate_password_length=6;
    ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘111111’ PASSWORD EXPIRE NEVER;
    ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘111111’;
    image.png
    默认只能本地连接，需开启远程连接
    image.png
    use mysql;
    update user set host=’%’ where user = ‘root’;
    image.png
    重启服务
    systemctl restart mysqld
    image.png
    image.png