Centos7安装mysql8

安装mysql

# 从国内镜像下载mysql8
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql80-community-release-el7-3.noarch.rpm

# 安装
yum install mysql80-community-release-el7-3.noarch.rpm

# 下载完成后，yum安装
yum install mysql-server

# 查看是否开机启动
systemctl list-unit-files|grep mysql
#mysqld.service                                enabled 	开机启动
#mysqld@.service                               disabled

# 如果不是开机启动，设置开机启动
systemctl enable mysqld.service
#启动mysql
systemctl start mysqld.service

# 初始化mysql
mysqld --initialize

# 查看初始化root密码
grep 'temporary password' /var/log/mysqld.log
#[root@localhost hao]# grep 'temporary password' /var/log/mysqld.log 
#2021-09-06T09:14:23.235555Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 8JmeNwgQd-DZ

# 登录
mysql -u root -p
# 出现下面提示后输入上面密码：8JmeNwgQd-DZ
Enter password:

配置mysql

# 修改初始化密码
alter user 'root'@'localhost' identified by '这里输入新密码';

# 如果搭建测试环境，可以修改密码策略，设置简易密码
# 查看密码策略
show variables like 'validate_password%';

# 设置密码复杂度为低
set global validate_password.policy=0;

#设置密码长度
set global validate_password.length=1;

# 创建新用户，这里如果执行create user 'user01'@'localhost' identified by '123456'; 只允许本地访问
create user 'user01'@'%' identified by '123456';

# 用户授权
grant all on *.* to 'user01'@'%';

现在可以用用户user01远程连接数据库，远程连接一定要设置serverTimeZone=Asia/Shanghai