MySQL8.x-Centos7离线安装Mysql8.x

1.下载

• 下载地址 https://downloads.mysql.com/archives/community/
  

2.上传、解压、安装

• 上传tar包，解压

tar -xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

• 安装

yum localinstall -y mysql-community-common-8.0.20-1.el7.x86_64.rpm && \
yum localinstall -y mysql-community-libs-8.0.20-1.el7.x86_64.rpm && \
yum localinstall -y mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm && \
yum localinstall -y mysql-community-devel-8.0.20-1.el7.x86_64.rpm && \
yum localinstall -y mysql-community-client-8.0.20-1.el7.x86_64.rpm && \
yum localinstall -y mysql-community-server-8.0.20-1.el7.x86_64.rpm

3.启动

• 启动服务,查看初始密码

systemctl start mysqld && systemctl enable mysqld

cat /var/log/mysqld.log | grep password

• 登录、修改密码、修改登陆规则、刷新（按顺序执行）

$ mysql -uroot -p'初始密码？？？？'

$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '15144042132@163.Com';

$ use mysql;

$ update user set host='%' where host='localhost';

$ delete from user where host !='%';

$ flush privileges;

$ SHOW VARIABLES LIKE 'validate_password%';

$ set global validate_password.policy=0;

$ set global validate_password.length=4;

$ ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234qwer';

$ quit

4.测试

• 虚拟机需要关闭防火墙（我这里用的是虚拟机）， 阿里云需要开启入栈规则
• 关闭防火墙

$ sudo systemctl stop firewalld && sudo systemctl disable firewalld
$ iptables -F  && firewall-cmd --state

账号 root
密码 1234qwer
主机 192.168.136.130