CentOS7 安装 MySQL8.0


一. 离线安装

mysql-8.0.16-2.el7.x86_64.rpm-bundle
迅雷链接：​​​https://pan.xunlei.com/s/VMNpu8tE5X1nCeHjWbi3liHWA1​​​ 提取码：​​9tet​​

官网地址：​​https://dev.mysql.com/downloads/mysql/​​

CentOS7 安装 MySQL8.0_centos

1.卸载mariadb

rpm -qa|grep mariadb
rpm -e mariadb-libs --nodeps

2.创建文件夹

cd /cd usr/local
mkdir mysql

创建完文件夹之后, 将压缩包放到mysql文件夹下面

3.安装

# 解压
tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar
# 安装解压的4个安装包
rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm --nodeps --force

CentOS7 安装 MySQL8.0_centos_02

4.初始化并启动

# 初始化
mysqld --initialize
# 赋权
chown mysql:mysql /var/lib/mysql -R
# 启动mysql
systemctl start mysqld.service
# 开机自启
systemctl enable mysqld
# 查看默认密码
cat /var/log/mysqld.log | grep password
# 登录, 密码为查看默认的密码
mysql -uroot -p
# 修改密码(密码需要数字，大小写字母，特殊符号)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Jack2020,,';
# 创建远程访问(要开启相应端口)
create user 'root'@'%' identified with mysql_native_password by 'Jack2020,,';
# 赋权
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

二. yum安装(总是失败)

查看官方最新yum源:​​https://dev.mysql.com/downloads/repo/yum/​​

1. 下载yum源

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

CentOS7 安装 MySQL8.0_yum_03
CentOS7 安装 MySQL8.0_yum_04
CentOS7 安装 MySQL8.0_linux_05
CentOS7 安装 MySQL8.0_mysql_06

如果遇到以下错误, 就在浏览器下载好放到服务器上
​​​ERROR: cannot verify repo.mysql.com's certificate, issued by ‘/C=US/O=DigiCert Inc/OU=www.digicert.com/CN=GeoTrust RSA CA 2018’: Issued certificate not yet valid. To connect to repo.mysql.com insecurely, use --no-check-certificate'.​​

2. 安装yum源

rpm -Uvh mysql80-community-release-el8-1.noarch.rpm

3. 查看mysql版本

yum repolist all | grep mysql

CentOS7 安装 MySQL8.0_安装_07

4. 安装

yum install -y mysql-community-server