安装MySQL8

安装Mysql8

# 查询是否存在mysql相关组件
$ yum search mysql-community
# 在官网 https://dev.mysql.com/downloads/repo/yum/ 下载
$ yum localinstall -y mysql80-community-release-el7-6.noarch.rpm 
# 再次运行
$ yum serach mysql-community
# 能查找到就运行
$ yum install -y mysql-community-server

快速安装方法

1. 百度搜索mysql 下载，进入官方MySQL :: Download MySQL Community Server

2. 选择Red Hat Enterprise Linux/Oracle Linux，版本看情况

3. 找到RPM Bundle，点击Download

4. 点击No thanks, just start my download下载MySQL80

5. 解压
   

6. 上传到服务器/var/cache/yum/x86_64/7/mysql80-community/packages

7. 运行 yum install -y mysql-community-server 等待安装完毕

获取 GPG 密钥失败：[Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"

8. 启动MySQLsystemctl start mysqld
9. 查看运行状态systemctl status mysqld
10. 设置自启动systemctl enable mysqld

初始化MySQL8

1. 进入vi /var/log/mysqld.log,查看密码
2. 进入MySQLmysql -r root -p，修改密码alter user 'root'@'localhost' identified with mysql_native_password by'密码';
3. 设置远程连接
   1. use mysql切换到mysql数据库
   2. 执行语句select host,user from user;
   3. 将root用户host改成%(代表任意设备都可以使用)update user set host='%' where user='root';
   4. 让权限立即生效flush privileges;