# 停止MySQL相關(guān)服務(wù)
systemctl stop mysqld
systemctl stop mariadb

# 卸載現(xiàn)有MySQL/MariaDB包
rpm -qa | grep -i mysql | xargs rpm -e --nodeps 2>/dev/null
rpm -qa | grep mariadb | xargs rpm -e --nodeps 2>/dev/null

# 清理殘留文件和目錄
rm -rf /var/lib/mysql
rm -rf /etc/my.cnf
rm -rf /etc/my.cnf.d
rm -rf /var/log/mysqld.log
rm -rf /usr/share/mysql
rm -rf /usr/lib64/mysql

# 清理yum緩存
yum clean all

scp /本地路徑/mysql-8.0.37-1.el7.x86_64.rpm-bundle.tar root@服務(wù)器IP:/tmp/

yum install -y libaio numactl

cd /tmp
tar -xvf mysql-8.0.37-1.el7.x86_64.rpm-bundle.tar

# 1. 安裝公共文件
yum install -y mysql-community-common-8.0.37-1.el7.x86_64.rpm

# 2. 安裝客戶端插件（這是關(guān)鍵依賴包）
yum install -y mysql-community-client-plugins-8.0.37-1.el7.x86_64.rpm

# 3. 安裝共享庫
yum install -y mysql-community-libs-8.0.37-1.el7.x86_64.rpm

# 4. 安裝ICU數(shù)據(jù)文件
yum install -y mysql-community-icu-data-files-8.0.37-1.el7.x86_64.rpm

# 5. 安裝客戶端工具
yum install -y mysql-community-client-8.0.37-1.el7.x86_64.rpm

# 6. 安裝MySQL服務(wù)器
yum install -y mysql-community-server-8.0.37-1.el7.x86_64.rpm

rpm -ivh mysql-community-*.rpm --nodeps --force

systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

grep 'temporary password' /var/log/mysqld.log

# 使用臨時(shí)密碼登錄
mysql -u root -p

# 在MySQL中執(zhí)行以下命令：
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourStrongPassword123!';
FLUSH PRIVILEGES;
EXIT;

mysql -u root -p

-- 創(chuàng)建允許遠(yuǎn)程連接的root用戶
CREATE USER 'root'@'%' IDENTIFIED BY 'YourStrongPassword123!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

-- 或者修改現(xiàn)有root用戶
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourStrongPassword123!';
RENAME USER 'root'@'localhost' TO 'root'@'%';

FLUSH PRIVILEGES;
EXIT;

# 備份原配置
cp /etc/my.cnf /etc/my.cnf.bak

# 添加遠(yuǎn)程訪問配置
cat >> /etc/my.cnf << EOF

# 允許遠(yuǎn)程連接
bind-address = 0.0.0.0

# 字符集設(shè)置
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

# 默認(rèn)認(rèn)證插件（兼容舊客戶端）
default_authentication_plugin = mysql_native_password
EOF

firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload

# 檢查SELinux狀態(tài)
getenforce

# 如為Enforcing模式，可臨時(shí)設(shè)置為Permissive
setenforce 0

# 或永久禁用（編輯/etc/selinux/config）
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

systemctl restart mysqld

# 檢查版本
mysql --version

# 本地連接測試
mysql -u root -p -e "SELECT version();"

# 檢查用戶權(quán)限
mysql -u root -p -e "SELECT user, host FROM mysql.user;"

# 檢查端口監(jiān)聽
netstat -tlnp | grep 3306

mysql -h 服務(wù)器IP -u root -p -e "SELECT '遠(yuǎn)程連接成功' as status;"

# 運(yùn)行安全配置腳本
mysql_secure_installation

# 停止MySQL
systemctl stop mysqld

# 跳過權(quán)限檢查啟動(dòng)
mysqld_safe --skip-grant-tables &

# 修改密碼
mysql -u root
UPDATE mysql.user SET authentication_string='' WHERE User='root';
FLUSH PRIVILEGES;
EXIT;

# 重啟MySQL
systemctl restart mysqld