Spring Cloud Alibaba（2）——安装MySQL8

1、MySQL8的下载和安装

wget https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
rpm -ivh mysql80-community-release-el7-11.noarch.rpm
yum install -y mysql-community-server 

2、启动MySQL

systemctl start mysqld

3、查看MySQL版本

mysql -V

4、设置MySQL为开机自启动

systemctl enable mysqld
systemctl daemon-reload

5、查看默认密码

grep 'temporary password' /var/log/mysqld.log

6、进入MySQL

# 命令行输入，密码就是上面查到的
mysql -u root -p

7、MySQL配置

# 先设置一个符合策略的密码
alter user 'root'@'localhost' identified by 'Abc123...';

# 修改校验密码策略等级
set global validate_password.policy=LOW;

# 设置密码长度至少为6
set global validate_password.length=6;

# 再设置为123456
alter user 'root'@'localhost' identified by '123456';
# 刷新系统权限相关表
flush privileges;

# 开启远程访问
use mysql;
UPDATE user SET host = '%' WHERE user ='root';
# 刷新系统权限相关表
flush privileges; 

8、测试