测试派 Give testers a home.

本文基于CentOS-7-x86_64-Minimal-2003.iso镜像版本：

yum安装mysql：

1.wget  https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm <br/>
2. yum   localinstall  mysql80-community-release-el7-3.noarch.rpm <br/>
3.yum -y install mysql-community-server //安装mysql服务器<br/>
4.systemctl start  mysqld.service  // 启动mysql服务<br/>
5.vim /etc/my.cnf  //查看得到log-error=/var/log/mysqld.log路径<br/>
6.vim /var/log/mysqld.log // 过滤得到初始密码（见下图）<br/>
7.mysql -u root -p //输入密码登录并修改密码<br/>
8.ALTER USER 'root' @'localhost' IDENTIFIED BY '123456Sxd!';   // 密码默认规则是8位，大小写字母和特殊字符<br/>
9.show variables like "%validate%" // 查看变量。<br/>
10.set global validate_password.length=6; //设置变量值们也就是设置密码规则长度为6位<br/>
11.set global validate_password.policy=0;//设置变量值们也就是设置密码规则为低等级low<br/>
12.ALTER USER 'root' @'localhost' IDENTIFIED BY '123456'; // 更新密码<br/>
13.firewall-cmd --permanent --add-port=3306/tcp //防火墙增加端口号<br/>
14.firewall-cmd --reload // 防火墙重启<br/>
15.登录mysql，并输入use mysql; // 使用mysql库<br/>
16.update user set host = '%' where user ='root' ;   // 这里的%号也可以设置为宿主机的ip地址----这里不更改你也可以试试有没有问题。<br/>
17.GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;    // 修改用户权限<br/>
18.flush privileges;   //刷新权限<br/>
ps：因为是破解版的navicat，而且mysql8.0前后版本的加密规则不同，因此有了下面3步骤。<br/>
19.ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;<br/>
20.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; <br/>
21.FLUSH PRIVILEGES; <br/>

参考文献：
https://www.cnblogs.com/blessYou/p/10766979.html

https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

https://www.cnblogs.com/yss818824/p/12349719.html