基于Rockylinux9.5(LTS-SP4)安装MySQL Community Server 9.2.0

目录

一、安装环境及准备

1、linux操作系统环境

2、MYSQL安装包准备 

二、执行安装

1、解压软件包

2、按顺序执行软件包的安装

3、启动MYSQL服务 

4.配置MYSQL

---

一、安装环境及准备

1、linux操作系统环境

• Rocky linux9.5安装在VMware虚拟机上
• 完成Rocky linux9.5安装，登录后如下图所示

• 安装软件包时选择server-gui安装，后期根据需要安装其它依赖包
• 详细版本查看

[root@mysql-master ~]# cat /etc/os-release
NAME="Rocky Linux"
VERSION="9.5 (Blue Onyx)"
ID="rocky"
ID_LIKE="rhel centos fedora"
VERSION_ID="9.5"
PLATFORM_ID="platform:el9"
PRETTY_NAME="Rocky Linux 9.5 (Blue Onyx)"
ANSI_COLOR="0;32"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:rocky:rocky:9::baseos"
HOME_URL="https://rockylinux.org/"
VENDOR_NAME="RESF"
VENDOR_URL="https://resf.org/"
BUG_REPORT_URL="https://bugs.rockylinux.org/"
SUPPORT_END="2032-05-31"
ROCKY_SUPPORT_PRODUCT="Rocky-Linux-9"
ROCKY_SUPPORT_PRODUCT_VERSION="9.5"
REDHAT_SUPPORT_PRODUCT="Rocky Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="9.5"

2、MYSQL安装包准备 

• MYSQL官网下载软件包，地址如下

https://dev.mysql.com/downloads/mysql/

• 选择相应版本，根据系统架构选择aarch64 架构版本或X86_64架构版本

• 将RPM软件包通过本机上传至Rockylinux服务器

二、执行安装

1、解压软件包

执行命令：tar -xvf mysql-9.2.0-1.el9.x86_64.rpm-bundle.tar，解压后文件列表如下，无需安装所有软件包。

[root@mysql-master installation]# tar -xvf mysql-9.2.0-1.el9.x86_64.rpm-bundle.tar
mysql-community-client-9.2.0-1.el9.x86_64.rpm
mysql-community-client-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-client-plugins-9.2.0-1.el9.x86_64.rpm
mysql-community-client-plugins-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-common-9.2.0-1.el9.x86_64.rpm
mysql-community-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-debugsource-9.2.0-1.el9.x86_64.rpm
mysql-community-devel-9.2.0-1.el9.x86_64.rpm
mysql-community-icu-data-files-9.2.0-1.el9.x86_64.rpm
mysql-community-libs-9.2.0-1.el9.x86_64.rpm
mysql-community-libs-compat-9.2.0-1.el9.x86_64.rpm
mysql-community-libs-compat-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-libs-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-server-9.2.0-1.el9.x86_64.rpm
mysql-community-server-debug-9.2.0-1.el9.x86_64.rpm
mysql-community-server-debug-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-server-debuginfo-9.2.0-1.el9.x86_64.rpm
mysql-community-test-9.2.0-1.el9.x86_64.rpm
mysql-community-test-debuginfo-9.2.0-1.el9.x86_64.rpm

2、按顺序执行软件包的安装

（1）、安装rpm -ivh mysql-community-common-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master installation]# rpm -ivh mysql-community-common-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-common-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-common-9.2.0-1.el################################# [100%]

（2）、安装mysql-community-client-plugins-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-client-plugins-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-client-plugins-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-client-plugins-9.################################# [100%]

（3）、 安装mysql-community-libs-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-libs-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-libs-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-libs-9.2.0-1.el9 ################################# [100%]

（4）、安装mysql-community-devel-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-devel-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-devel-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-devel-9.2.0-1.el9################################# [100%]

        以上如果报错：warning: mysql-community-devel-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY error: Failed dependencies: pkgconfig(openssl) is needed by mysql-community-devel-9.2.0-1.el9.x86_64，那么需要安装 openssl-devel开发包，命令如下：yum install openssl-devel -y，之后再执行上面的安装命令，安装成功。

 （5）、安装mysql-community-libs-compat-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-libs-compat-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-libs-compat-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-libs-compat-9.2.0################################# [100%]

（6）、安装mysql-community-client-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-client-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-client-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-client-9.2.0-1.el################################# [100%]

（7）、安装mysql-community-icu-data-files-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-icu-data-files-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-icu-data-files-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-icu-data-files-9.################################# [100%]

（8）、安装mysql-community-server-9.2.0-1.el9.x86_64.rpm包

[root@mysql-master mysql]# rpm -ivh mysql-community-server-9.2.0-1.el9.x86_64.rpm
warning: mysql-community-server-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-server-9.2.0-1.el################################# [100%]

3、启动MYSQL服务 

（1）、查看服务状态，可以看到安装完成后并未启动

[root@mysql-master mysql]# systemctl status mysqld
○ mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; preset: disabled)Active: inactive (dead)Docs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.html

（2）、启动MYSQL服务并设置服务为开机启动

执行:systemctl start mysqld，systemctl enable mysqld

4.配置MYSQL

（1）、执行如下命令查询初始密码，其中字符串Zu/yW/(>S4w=为初始密码，然后登录数据库

[root@mysql-master mysql]# cat /var/log/mysqld.log | grep password
2025-03-20T01:57:43.659699Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Zu/yW/(>S4w=
[root@mysql-master ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 9.2.0Copyright (c) 2000, 2025, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

（2）、修改数据库密码，创建用户并授权

mysql> SET PASSWORD FOR 'root'@'localhost'= "Mysql12#$";
Query OK, 0 rows affected (0.01 sec)
mysql> CREATE USER '***'@'%' IDENTIFIED BY 'Mysql12#$';
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO '***'@'%';
Query OK, 0 rows affected (0.00 sec)

        如果需要root有远程访问的权限需要做如下配置:

• 确保 root 用户拥有足够的权限： GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;    
• 刷新权限： FLUSH PRIVILEGES;      

通过以上步骤完成配置