CentOS7安装MySQL 8.0.x修改root密码

一、使用无密码登录

# vim /etc/my.cnf

添加：skip-grant-table

# systemctl stop mysqld.service

#systemctl start mysqld.service

# mysql –u root -p

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> alter user 'root'@'localhost'IDENTIFIED BY 'MyNewPass';

ERROR 1819 (HY000): Your password does notsatisfy the current policy requirements

mysql> alter user'root'@'localhost' IDENTIFIED BY 'MyNewPass@123';

mysql8.0以上密码策略限制必须要大小写加数字特殊符号，我之前用mysqladmin,set,update，参考修改root密码的前人：http://www.cnblogs.com/liufei88866/p/5619215.html】

Query OK, 0 rows affected (0.05 sec) 

mysql> quit;

# vim /etc/my.cnf

把【Skip-grant-table】语句删除或注释.

重新启动数据库

[root@localhost ~]# systemctl stop mysqld.service

[root@localhost ~]# systemctl start mysqld.service

[root@localhost ~]# mysq