grep"password" /var/log/mysqld.log
mysql -uroot -p
修改密码规则,并将登录密码修改为123456
ALTER USER'root'@'localhost' IDENTIFIED BY 'Password0.0';
SHOW VARIABLES LIKE 'validate_password%';set global validate_password_policy=0;set global validate_password_length=1;
ALTER USER'root'@'localhost' IDENTIFIED BY '123456';
配置远程访问MySQL
use mysql;
CREATE USER'root'@'%' IDENTIFIED BY 'KC$abc123';select host, user, authentication_string, plugin from user;
GRANT ALL PRIVILEGES ON*.* TO 'root'@'%';
ALTER USER'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
ALTER USER'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;