linux yum安装mysql步骤

一、yum仓库

# 1、下载MySQL官方YUM仓库包（选择对应版本）
# MySQL 8.0
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

# 2、更新yum源
sudo yum clean all
sudo yum makecache

二、yum安装：如果yum 安装失败执行步骤2

#1、yum 安装
sudo yum install mysql-community-server

#2、如果上面报错提示Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022用下面方式
# 方式一、下载密钥；如果还不行，下载最新年份密钥
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpmsudo yum clean all
sudo yum install mysql-community-server

# 方式二、临时跳过CPG检查
sudo yum install mysql-community-server --nogpgcheck

三、启动服务

sudo systemctl start mysqld
sudo systemctl enable mysqld  # 设置开机自启

四、获取临时密码

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

五、运行安全向导，输入旧密码和两次新密码后yes

sudo mysql_secure_installation

六、开启远程访问

CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%';
FLUSH PRIVILEGES;