CentOS7 安装 MySQL8.0

• ​​一. 离线安装​​

• ​​1.卸载mariadb​​
• ​​2.创建文件夹​​
• ​​3.安装​​
• ​​4.初始化并启动​​

• ​​二. yum安装(总是失败)​​

• ​​1. 下载yum源​​
• ​​2. 安装yum源​​
• ​​3. 查看mysql版本​​
• ​​4. 安装​​

一. 离线安装

mysql-8.0.16-2.el7.x86_64.rpm-bundle

迅雷链接：​​​https://pan.xunlei.com/s/VMNpu8tE5X1nCeHjWbi3liHWA1​​​ 提取码：​

​9tet​

​

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

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      

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      

如果遇到以下错误, 就在浏览器下载好放到服务器上

​​

​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      

4. 安装

yum install -y mysql-community-server