# 0 解壓文件
tar -xf mysql-8.4.6-1.el9.x86_64.rpm-bundle.tar

# 1. 先安裝通用包和庫(kù)文件
rpm -ivh mysql-community-common-8.4.6-1.el9.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.4.6-1.el9.x86_64.rpm
rpm -ivh mysql-community-libs-8.4.6-1.el9.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.4.6-1.el9.x86_64.rpm

# 2. 安裝客戶端
rpm -ivh mysql-community-client-8.4.6-1.el9.x86_64.rpm

# 3. 安裝服務(wù)器
rpm -ivh mysql-community-server-8.4.6-1.el9.x86_64.rpm

報(bào)錯(cuò)
# 安裝 ICU 數(shù)據(jù)文件包
rpm -ivh mysql-community-icu-data-files-8.4.6-1.el9.x86_64.rpm
# 導(dǎo)入 MySQL GPG 密鑰
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023

# 啟動(dòng) MySQL 服務(wù)
systemctl start mysqld

# 設(shè)置開(kāi)機(jī)自啟動(dòng)
systemctl enable mysqld

# 檢查服務(wù)狀態(tài)
systemctl status mysqld


# 獲取臨時(shí)密碼
grep 'temporary password' /var/log/mysqld.log

# 使用臨時(shí)密碼登錄并設(shè)置新密碼
mysql -u root -p

-- 修改 root 密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

-- 刷新權(quán)限
FLUSH PRIVILEGES;

-- 退出 MySQL
EXIT;


# 使用新密碼登錄驗(yàn)證
mysql -u root -p
# 輸入新密碼：123456


# 登錄后檢查版本
SELECT VERSION();


# 配置文件路徑
 /etc/my.cnf 
# 重啟MySQL（修改配置文件需要重啟）
sudo systemctl restart mysqld 


# MySQL服務(wù)開(kāi)通對(duì)外訪問(wèn)權(quán)限
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

# 防火墻開(kāi)放3306端口
sudo firewall-cmd --permanent --add-port=3306/tcp
sudo firewall-cmd --reload

# 查詢防火墻 3306端口是否開(kāi)放
sudo firewall-cmd --list-all | grep 3306