centos 安装mysql 8

1. rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
   默认安装的是最新版本8.0，如果要安装其它版本
   (vi /etc/yum.repos.d/mysql-community.repo mysql80 enabled设为0 其他版本enabled设为1)

2. yum -y install mysql-community-server mysql-community-devel

3. systemctl enable mysqld

4. systemctl start mysqld

5. grep “password” /var/log/mysqld.log

6. mysql -uroot -p

7. ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘new password’;
   或者 update mysql.user set authentication_string=PASSWORD(‘test’) where user=‘root’ and host=‘localhost’;
   如 报satisfy错运行

8. mysql 8以下运行 set global validate_password_policy=0

9. set global validate_password_length=4
   mysql8 运行
   set global validate_password.policy=0;
   set global validate_password.length=1;

10. update mysql.user set Host=’%’ where HOST=‘localhost’ and User=‘root’; // 允许远程登录

11. flush privileges;