sudo dnf remove -y mariadb*sudo dnf autoremove -y# 删除残留目录sudo rm -rf /var/lib/mysql /etc/my.cnf

# 下载MySQL官方rpm源包sudo dnf install -y https://dev.mysql.com/get/mysql80-community-release-el9-3.noarch.rpm# 刷新缓存sudo dnf makecache

sudo dnf install -y mysql-community-server mysql-community-client mysql-community-devel

# 下载2023最新公钥并导入系统rpm信任列表sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2023# 清理旧缓存sudo dnf clean allsudo dnf makecache

sudo systemctl enable --now mysqld# 查看运行状态sudo systemctl status mysqld

sudo grep 'temporary password' /var/log/mysqld.log# 输出类似：root@localhost: xxxxxxxx

sudo mysql_secure_installation

sudo firewall-cmd --add-port=3306/tcp --permanentsudo firewall-cmd --reload

# 登录MySQLmysql -uroot -p# 输入你设置的密码

# 授权所有IP远程访问rootCREATE USER 'root'@'%' IDENTIFIED BY 'xxxxxx';GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;FLUSH PRIVILEGES;exit;

vim /etc/my.cnf

[mysqld]port=3306socket=/var/lib/mysql/mysql.sockdatadir=/var/lib/mysqlcharacter-set-server=utf8mb4collation-server=utf8mb4_unicode_cidefault-time_zone = '+8:00'# 解决MySQL8默认密码插件Navicat低版本报错default_authentication_plugin=mysql_native_password[mysql]default-character-set=utf8mb4

sudo systemctl restart mysqld

# 启停systemctl start mysqldsystemctl stop mysqldsystemctl restart mysqld# 实时日志tail -f /var/log/mysqld.log# 登录本地mysql -uroot -p

sudo systemctl stop mysqldsudo dnf remove mysql-community* -ysudo rm -rf /var/lib/mysql /etc/my.cnf /var/log/mysqld.logsudo dnf autoremove -y