1. 彻底清理(慎用)
rm -rf /var/lib/mysql/*
vi /etc/my.cnf
[mysqld]
skip_grant_tables # 免密登录
systemctl restart mysqld
# 清除root密码
>mysql
mysql> update mysql.user set authentication_string='' where user='root';
mysql> update mysql.user set host = '%' where user='root';
mysql> FLUSH PRIVILEGES;
# 重置root密码
mysql_secure_installation
# 先按照要求定义复杂密码
# 再将复杂密码替换
>mysql -u root -p
mysql> set global validate_password.policy=LOW;
mysql> FLUSH PRIVILEGES;
mysql> set password='xxx';
2.时区设置
# vim /etc/my.cnf ##在[mysqld]区域中加上
default-time_zone = '+8:00'
> systemctl restart mysqld
mysql> show variables like '%time_zone%';
mysql> set global time_zone = '+8:00';
mysql> set time_zone = '+8:00';
mysql> FLUSH PRIVILEGES;