CentOS8下安装MySQL8.0.27（rpm包安装方式）

---

一、下载

下载地址：https://dev.mysql.com/downloads/mysql/8.0.html

二、解压

tar xvf mysql-8.0.27-1.el8.x86_64.rpm-bundle.tar

三、按顺序安装rpm包

rpm -ivh mysql-community-common-8.0.27-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el8.x86_64.rpm
rpm -ivh libaio-0.3.112-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el8.x86_64.rpm

四、启动

systemctl start mysqld

五、找到初始密码

cat /var/log/mysqld.log | grep ‘password is generated’

六、修改密码并授权

alter user ‘root’@‘localhost’ identified by ‘xxxxxx’;
CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘xxxxxx’;
grant all privileges on . to ‘root’@‘%’;
flush privileges;

七、开启防火墙，允许外网访问

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-ports