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