CentOS8安装mysql8详细步骤

1、安装wget

yum -y install wget

2、采取wget下载mysql8安装包

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3、安装yum源

yum -y localinstall mysql80-community-release-el7-3.noarch.rpm

4、安装mysql服务

yum -y install mysql-community-server

如显示：显示公钥尚未安装，执行以下命令，或者考虑直接使用以下命令，省去yum -y install mysql-community-server试试

yum install -y mysql-community-server --nogpgcheck

5、启动mysql服务

systemctl start mysqld

6、设置开机自启

• 设置自启

  systemctl enable mysqld

• 重启systemctl

  systemctl daemon-reload

7、通过初始密码登陆mysql

mysql -u root -p

    使用初始密码登录（mysqld.log查初始密码）

8、修改初始密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123@'

9、设置远程登录

CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password  BY 'Root123@';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;

10、开放端口

firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload