Alibaba Cloud Linux安裝mysql8
安裝
添加數(shù)據(jù)源
yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
安裝
yum install mysql-community-server
如果報(bào)錯(cuò)
MySQL 8.0 Community Server 27 MB/s | 27 kB 00:00
導(dǎo)入 GPG 公鑰 0x5072E1F5:
Userid: "MySQL Release Engineering <mysql-build@oss.oracle.com>"
指紋: A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5
來自: /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
確定嗎？[y/N]： y
導(dǎo)入公鑰成功
導(dǎo)入的密鑰沒有公鑰，錯(cuò)誤的公鑰？
mysql-community-client-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-client-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql-community-client-plugins-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-client-plugins-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql-community-common-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-common-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql-community-icu-data-files-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-icu-data-files-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql-community-libs-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-libs-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql-community-server-8.0.36-1.el7.x86_64.rpm 的公鑰沒有安裝. 失敗的軟件包是：mysql-community-server-8.0.36-1.el7.x86_64
GPG密鑰配置為：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
下載的軟件包保存在緩存中，直到下次成功執(zhí)行事務(wù)。
您可以通過執(zhí)行 'yum clean packages' 刪除軟件包緩存。
錯(cuò)誤：GPG 檢查失敗
導(dǎo)入公鑰后執(zhí)行yum install mysql-community-server
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023
安裝openssl
yum install compat-openssl10
啟動(dòng)mysql服務(wù)
systemctl start mysqld
獲取默認(rèn)密碼
cat /var/log/mysqld.log | grep password
登錄
mysql -u root -p
修改密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';
開啟遠(yuǎn)程登錄
創(chuàng)建用戶
create user 'qdcosin'@'%' identified with mysql_native_password by 'xxx';
grant all privileges on * .* to 'qdcosin'@'%';
然后嘗試使用navicat測(cè)試遠(yuǎn)程登錄
其它mysql命令
# 刪除用戶
DROP USER 'qdcosin'@'%';
