Centso7安装MySQL 8.0记录

1.备份yum源

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

2.下载yum阿里源

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

3.清理yum缓存，并生成新的缓存

yum clean all
yum makecache

4.更新yum源

yum update

5.安装wget命令

yum install wget

6.获取rpm源

wget https://dev.mysql.com/get/mysql84-community-release-el7-1.noarch.rpm

7.安装rpm包

rpm -ivh mysql84-community-release-el7-1.noarch.rpm

8.查看启用的MySQL版本

yum repolist all | grep mysql

9.禁用8.4版本，并启用8.0版本

yum-config-manager --disable mysql-8.4-lts-community
yum-config-manager --disable mysql-tools-8.4-lts-community
yum-config-manager --enable  mysql80-community
yum-config-manager --enable  mysql-tools-community

 10.安装mysql

yum install mysql-community-server

 

11.启动mysql服务器

systemctl start mysqld

12.查看服务状态

systemctl status mysqld

13.查看初始密码

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

 

 14.使用临时密码登录

mysql -uroot -p

15.修改密码(默认密码规则是：最少四位，同时出现字母、数字、特殊符号)

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

16.查看密码规则

SHOW VARIABLES LIKE 'validate_password%';

 

17.修改密码规则(降低密码复杂度，允许使用简单密码)

set global validate_password.check_user_name=0;
set global validate_password.length=1;
set global validate_password.number_count=0;
set global validate_password.policy=0;
set global validate_password.special_char_count=0;

18.再次修改密码为简单密码(root)

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

至此，数据库基本配置完成。