【mysql】centos安装mysql8

1.下载MySQL80

yum -y install wget
wget https://repo.mysql.com/mysql80-community-release-el7-4.noarch.rpm

具体下载什么版本可以从下面链接查找:

MySQL :: Download MySQL Yum Repositoryhttps://dev.mysql.com/downloads/repo/yum/

mysql-yum-repositoryhttps://repo.mysql.com/

 2.安装MySQL80仓库

rpm -ivh mysql80-community-release-el7-4.noarch.rpm

3.安装MySQL80

yum install mysql-server

Failing package is:mysql-community-icu-data-files-8.0.29-1.el7.x86_64 GPG Keys are configured as.. 

如果遇到报错如上报错，则执行下面的命令，原因是mysql的gpg升级了

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

4.启动MySQL80服务

systemctl start mysqld
 
查看服务运行状态
systemctl status mysqld

5.登录前需要先获取安装时生成的随机密码

grep 'temporary password' /var/log/mysqld.log

6.登录命令

mysql -uroot -p

7.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
 
如果设置为简单密码，关闭密码校验规则
set global validate_password.policy=0;
set global validate_password.length=1;
 

8.授权账号远程登录

CREATE USER `root`@`%` IDENTIFIED BY 'test';
GRANT ALL ON *.* TO `root`@`%` WITH GRANT OPTION;

9.添加防火墙端口号

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