基于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安装，后期根据需要安装其它依赖包
  • 详细版本查看
  1. [root@mysql-master ~]# cat /etc/os-release
  2. NAME="Rocky Linux"
  3. VERSION="9.5 (Blue Onyx)"
  4. ID="rocky"
  5. ID_LIKE="rhel centos fedora"
  6. VERSION_ID="9.5"
  7. PLATFORM_ID="platform:el9"
  8. PRETTY_NAME="Rocky Linux 9.5 (Blue Onyx)"
  9. ANSI_COLOR="0;32"
  10. LOGO="fedora-logo-icon"
  11. CPE_NAME="cpe:/o:rocky:rocky:9::baseos"
  12. HOME_URL="https://rockylinux.org/"
  13. VENDOR_NAME="RESF"
  14. VENDOR_URL="https://resf.org/"
  15. BUG_REPORT_URL="https://bugs.rockylinux.org/"
  16. SUPPORT_END="2032-05-31"
  17. ROCKY_SUPPORT_PRODUCT="Rocky-Linux-9"
  18. ROCKY_SUPPORT_PRODUCT_VERSION="9.5"
  19. REDHAT_SUPPORT_PRODUCT="Rocky Linux"
  20. 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，解压后文件列表如下，无需安装所有软件包。

    1. [root@mysql-master installation]# tar -xvf mysql-9.2.0-1.el9.x86_64.rpm-bundle.tar
    2. mysql-community-client-9.2.0-1.el9.x86_64.rpm
    3. mysql-community-client-debuginfo-9.2.0-1.el9.x86_64.rpm
    4. mysql-community-client-plugins-9.2.0-1.el9.x86_64.rpm
    5. mysql-community-client-plugins-debuginfo-9.2.0-1.el9.x86_64.rpm
    6. mysql-community-common-9.2.0-1.el9.x86_64.rpm
    7. mysql-community-debuginfo-9.2.0-1.el9.x86_64.rpm
    8. mysql-community-debugsource-9.2.0-1.el9.x86_64.rpm
    9. mysql-community-devel-9.2.0-1.el9.x86_64.rpm
    10. mysql-community-icu-data-files-9.2.0-1.el9.x86_64.rpm
    11. mysql-community-libs-9.2.0-1.el9.x86_64.rpm
    12. mysql-community-libs-compat-9.2.0-1.el9.x86_64.rpm
    13. mysql-community-libs-compat-debuginfo-9.2.0-1.el9.x86_64.rpm
    14. mysql-community-libs-debuginfo-9.2.0-1.el9.x86_64.rpm
    15. mysql-community-server-9.2.0-1.el9.x86_64.rpm
    16. mysql-community-server-debug-9.2.0-1.el9.x86_64.rpm
    17. mysql-community-server-debug-debuginfo-9.2.0-1.el9.x86_64.rpm
    18. mysql-community-server-debuginfo-9.2.0-1.el9.x86_64.rpm
    19. mysql-community-test-9.2.0-1.el9.x86_64.rpm
    20. 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包

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

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

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

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

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

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

    1. [root@mysql-master mysql]# rpm -ivh mysql-community-devel-9.2.0-1.el9.x86_64.rpm
    2. warning: mysql-community-devel-9.2.0-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
    3. Verifying...                          ################################# [100%]
    4. Preparing...                          ################################# [100%]
    5. Updating / installing...
    6.    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包

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

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

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

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

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

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

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

    3、启动MYSQL服务 

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

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

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

    执行:systemctl start mysqld，systemctl enable mysqld

    4.配置MYSQL

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

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

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

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

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

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

    通过以上步骤完成配置

    注：本文转载自blog.csdn.net的pengdott的文章"https://blog.csdn.net/pengdott/article/details/146368445"。版权归原作者所有，此博客不拥有其著作权，亦不承担相应法律责任。如有侵权，请联系我们删除。
    复制链接
    相关推荐
    发表评论

    评论记录：

    未查询到任何数据！