Centos7 MySQL8.0.2.0安装

Centos7 MySQL8.0.2.0 安装

1、下载

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

2.上传并解压
xshell上传tar包，然后解压
$ tar xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

安装

2、安装（这是一条命令）

$ rpm -e --nodeps mariadb-libs &&
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.启动
如图，启动服务,查看初始密码

3、启动服务,查看初始密码

$ systemctl start mysqld &&
systemctl enable mysqld &&
cat /var/log/mysqld.log | grep password

登录，修改密码，修改登陆规则，刷新

4、登录，修改密码，修改登陆规则，刷新

$ mysql -uroot -p’初始密码？？？？’
mysql> $ ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘15144042132@163.Com’;
mysql> $ use mysql;
mysql> $ update user set host=’%’ where host=‘localhost’;
mysql> $ delete from user where host !=’%’;
mysql> $ flush privileges;
mysql> $ SHOW VARIABLES LIKE ‘validate_password%’;
mysql> $ set global validate_password.policy=0;
mysql> $ set global validate_password.length=4;
mysql> $ ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘1234qwer’;
mysql> $ quit

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

5、关闭防火墙

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

账号 root
密码 1234qwer
主机 192.168.136.130

原文转载https://blog.csdn.net/m0_37969197/article/details/107382467