CentOS7下安装MySQL8.0.28

本文主要是介绍CentOS7下安装MySQL8.0.28，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

---

一、下载

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

二、解压

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

三、按顺序安装rpm包

rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm

注意：执行过程中可能报错：mariadb-libs is obsoleted by mysql-community-libs-8.0.28-1.el7.x86_64，解决方法见：https://blog.csdn.net/u012069313/article/details/123185605

四、启动

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

这篇关于CentOS7下安装MySQL8.0.28的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---