centos7下mysql8安装

1.下载repo源

yum localinstall http://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm

2.安装mysql

yum -y install mysql-community-server

3.启动服务

systemctl start  mysqld.service 

4.查看默认密码

grep password /var/log/mysqld.log

5.登录

mysql -uroot -p

6.修改密码

  8和以前的版本的老版本不一样，需要先修改密码再修改策略再修改密码，不然不能改成简单的密码

ALTER USER USER() IDENTIFIED BY 'J2Xzi!bui9y1';
set global validate_password.policy=0;
set global validate_password.length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

7.退出重新用新密码登录

8.添加开机启动

systemctl enable mysqld.service

注意：如果yum -y install mysql-community-server下载很慢，我们可以从其他地方下载文件

执行安装之后缓存文件在/var/cache/yum/x86_64/7/mysql80-community/packages

我们从网易下载这2个包，然后覆盖缓存文件，然后重新安装

wget -i -c http://uni.mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-client-8.0.27-1.el7.x86_64.rpm
wget -i -c http://uni.mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-community-server-8.0.27-1.el7.x86_64.rpm
yum -y install mysql-community-server