RockyLinux9环境下编译MySQL8

Liu Zijian's Blog | 一个技术博客

使用Certbot自动续签HTTPS证书使用Filebeat采集Nginx日志到ES Python的协程 Python中的异常 Python中的类和对象 Python的函数 Python的数据结构，推导式、迭代器和生成器 Spring AI集成多模态模型 LangChain4j多模态 LangChain Tools工具使用 Python中的模块和包 Python全局环境和虚拟环境（venv） LangChain Prompt提示词工程 LangChain4j Tools工具使用基于Dify搭建AI智能体应用 LangChain4j RAG检索增强生成 Spring AI实现MCP Server Spring AI集成MCP Client LangChain4j Prompt提示词工程 Spring AI使用知识库增强对话功能 Spring AI实现一个智能客服 Spring AI实现一个简单的对话机器人实现MinIO数据的每日备份自己实现一个DNS服务简单理解AI智能体大模型和大模型应用 LangChain开篇 LangChain4j开篇一个解析Excel2007的POI工具类 DataPermissionInterceptor源码解读

Liu Zijian · 2024-12-21 · via Liu Zijian's Blog | 一个技术博客

Linux版本: Rocky Linux release 9.5 (Blue Onyx)

1.下载

打开MySQL-Community-Server官方下载页面:https://downloads.mysql.com/archives/community/

筛选出要下载的版本，Product Version选择8.0.39，Operating System选择Source Code，OS Version选择All Operating Systems，然后选择最后一个自带boost的MySQL源码包All Operating Systems (Generic) (Architecture Independent), Compressed TAR Archive
Includes Boost Headers (mysql-boost-8.0.39.tar.gz)，进行下载，并将下载到的源码包先放到服务器的/opt目录下。

下载链接:

mysql-boost-8.0.39.tar.gz

https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-8.0.39.tar.gz

解压tar包，得到文件夹mysql-8.0.39，里面就是MySQL源码和一些构建信息

[root@localhost opt]# cd mysql-8.0.39/
[root@localhost mysql-8.0.39]# ll
total 684
-rw-r--r--.  1 7161 31415  94660 Jul 13 03:15 CMakeLists.txt
drwxr-xr-x.  2 7161 31415     65 Jul 13 03:43 Docs
-rw-r--r--.  1 7161 31415   5425 Jul 13 03:15 Doxyfile-ignored
-rw-r--r--.  1 7161 31415 123326 Jul 13 03:15 Doxyfile.in
-rw-r--r--.  1 7161 31415    333 Jul 13 03:15 INSTALL
-rw-r--r--.  1 7161 31415 282186 Jul 13 03:15 LICENSE
-rw-r--r--.  1 7161 31415    118 Jul 13 03:15 MYSQL_VERSION
-rw-r--r--.  1 7161 31415    666 Jul 13 03:15 README
drwxr-xr-x.  3 7161 31415     26 Jul 13 03:45 boost
drwxr-xr-x. 10 7161 31415   4096 Jul 13 03:43 client
drwxr-xr-x.  4 7161 31415   4096 Jul 13 03:43 cmake
drwxr-xr-x. 16 7161 31415   4096 Jul 13 03:43 components
-rw-r--r--.  1 7161 31415  10843 Jul 13 03:15 config.h.cmake
-rw-r--r--.  1 7161 31415  23642 Jul 13 03:15 configure.cmake
drwxr-xr-x.  3 7161 31415    124 Jul 13 03:43 doxygen_resources
drwxr-xr-x. 19 7161 31415   4096 Jul 13 03:43 extra
drwxr-xr-x.  4 7161 31415   8192 Jul 13 03:43 include
drwxr-xr-x.  5 7161 31415    112 Jul 13 03:43 libbinlogevents
drwxr-xr-x.  3 7161 31415     39 Jul 13 03:43 libbinlogstandalone
drwxr-xr-x.  4 7161 31415     54 Jul 13 03:43 libchangestreams
drwxr-xr-x.  7 7161 31415   4096 Jul 13 03:43 libmysql
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:43 libservices
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:45 man
drwxr-xr-x. 10 7161 31415   4096 Jul 13 03:43 mysql-test
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:43 mysys
drwxr-xr-x. 10 7161 31415    131 Jul 13 03:43 packaging
drwxr-xr-x. 25 7161 31415   4096 Jul 13 03:43 plugin
drwxr-xr-x.  6 7161 31415    155 Jul 13 03:43 router
-rw-r--r--.  1 7161 31415   6268 Jul 13 03:15 run_doxygen.cmake
drwxr-xr-x.  4 7161 31415   4096 Jul 13 03:43 scripts
drwxr-xr-x.  3 7161 31415    155 Jul 13 03:43 share
drwxr-xr-x. 24 7161 31415  24576 Jul 13 03:44 sql
drwxr-xr-x.  3 7161 31415   4096 Jul 13 03:43 sql-common
drwxr-xr-x. 14 7161 31415   4096 Jul 13 03:45 storage
drwxr-xr-x.  3 7161 31415   4096 Jul 13 03:43 strings
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:43 support-files
drwxr-xr-x.  2 7161 31415    101 Jul 13 03:43 testclients
drwxr-xr-x.  5 7161 31415     70 Jul 13 03:43 unittest
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:43 utilities
drwxr-xr-x.  2 7161 31415   4096 Jul 13 03:43 vio

和编译MySQl5.7一样，进入boost/文件夹下，查看boost是哪个版本，一会编译时会用到。

[root@localhost mysql-8.0.39]# cd boost/
[root@localhost boost]# ll
total 0
drwxr-xr-x. 3 7161 31415 19 Jul 13 03:45 boost_1_77_0

2.编译安装前准备

1.新添加一个用户: mysql

useradd mysql

2.安装编译所需依赖

dnf install -y make cmake gcc gcc-c++ ncurses-devel  openssl-devel libtirpc

还有些不能通过yum安装的软件包要手动下载安装

yum install -y wget

wget https://dl.rockylinux.org/pub/rocky/9/devel/x86_64/os/Packages/l/libtirpc-devel-1.3.3-9.el9.x86_64.rpm

wget https://dl.rockylinux.org/pub/rocky/9/AppStream/x86_64/os/Packages/r/rpcgen-1.4-9.el9.x86_64.rpm

rpm -ivh libtirpc-devel-1.3.3-9.el9.x86_64.rpm

rpm -ivh rpcgen-1.4-9.el9.x86_64.rpm

然后再安装MySQL8.0.39需要的gcc工具集，安装前，需要升级软件包libsemanage为高版本，同样需要下载软件包到本地，然后rpm -Uvh更新

wget https://dl.rockylinux.org/pub/rocky/9/BaseOS/x86_64/os/Packages/l/libsemanage-3.6-2.1.el9_5.x86_64.rpm

rpm -Uvh libsemanage-3.6-2.1.el9_5.x86_64.rpm

然后执行安装gcc工具集命令

yum install gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binutils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc

3./usr/local/下必须新建文件夹mysql

mkdir /usr/local/mysql

3.编译安装

1.在源码目录/opt/mysql-8.0.39下执行cmake命令，进行编译前的检查和配置，使用CMake配置和生成MySQL源码编译所需的构建系统文件，安装MySQL到/usr/local/mysql目录下，-DWITH_BOOST=的路径根据源码包内自带boost的版本而定，默认端口3306，数据路径/usr/local/mysql/data，字符集utf8mb4

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DINSTALL_DATADIR=/usr/local/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqld.sock \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DFORCE_INSOURCE_BUILD=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DWITH_BOOST=boost/boost_1_77_0/

2.cmake命令执行成功后，执行以下make命令开始编译安装，-j 2是同时开启两个线程编译，加速编译

make -j 2 && make install

执行后，开始编译，不断输出日志，编译的过程很耗时间，需要等待很久，编译完成后，可以在/usr/local/mysql目录下看到编译好的MySQL

[root@localhost mysql-8.0.39]# cd /usr/local/mysql/
[root@localhost mysql]# ll
total 704
-rw-r--r--.  1 root root 282186 Jul 13 03:15 LICENSE
-rw-r--r--.  1 root root 282186 Jul 13 03:15 LICENSE-test
-rw-r--r--.  1 root root 115948 Jul 13 03:15 LICENSE.router
-rw-r--r--.  1 root root    666 Jul 13 03:15 README
-rw-r--r--.  1 root root    666 Jul 13 03:15 README-test
-rw-r--r--.  1 root root    679 Jul 13 03:15 README.router
drwxr-xr-x.  2 root root   4096 Dec 21 18:08 bin
drwxr-xr-x.  2 root root     69 Dec 21 18:08 docs
drwxr-xr-x.  3 root root   4096 Dec 21 18:08 include
drwxr-xr-x.  6 root root   4096 Dec 21 18:08 lib
drwxr-xr-x.  4 root root     30 Dec 21 18:08 man
drwxr-xr-x. 10 root root   4096 Dec 21 18:08 mysql-test
-rw-r--r--.  1 root root   1672 Dec 21 13:33 mysqlrouter-log-rotate
drwxrwxr-x.  2 root root      6 Dec 21 18:08 run
drwxr-xr-x. 28 root root   4096 Dec 21 18:08 share
drwxr-xr-x.  2 root root     77 Dec 21 18:08 support-files
drwxr-xr-x.  3 root root     17 Dec 21 18:08 var

4.安装后配置

1.在/usr/local/mysql创建一个mysql配置文件，并写入字符集相关配置进去。

vi /usr/local/mysql/my.cnf

[mysqld]

port = 3306

character-set-server=utf8mb4
default_authentication_plugin=mysql_native_password


[mysql]
default-character-set=utf8mb4

2.在/usr/local/mysql下执行命令初始化MySQL数据库

./bin/mysqld  \
--defaults-file=/usr/local/mysql/my.cnf  \
--user=mysql \
--basedir=/usr/local/mysql  \
--datadir=/usr/local/mysql/data  \
--initialize-insecure

3.在/usr/local/mysql目录执行以下命令，将文件所有者设置为之前新建的mysql用户

chown -R mysql:mysql ./

5.启动和测试MySQL Server

在/usr/local/mysql下执行启动脚本文件启动数据库

./support-files/mysql.server start

关闭

./support-files/mysql.server stop

重启

./support-files/mysql.server restart

登录数据库测试，切换到目录/usr/local/mysql，执行./bin/mysql -uroot -p命令登录数据库，root密码默认是空

[root@localhost mysql]# ./bin/mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.39 Source distribution

Copyright (c) 2000, 2024, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

修改默认密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lzj';

修改后要刷新权限

mysql> FLUSH PRIVILEGES;

刷新权限后退出使用新密码再次登录，此时已经可以正常操作数据库了。

[root@localhost mysql]# ./bin/mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.39 Source distribution

Copyright (c) 2000, 2024, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.39    |
+-----------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | utf8mb4                          |
| character_set_connection | utf8mb4                          |
| character_set_database   | utf8mb4                          |
| character_set_filesystem | binary                           |
| character_set_results    | utf8mb4                          |
| character_set_server     | utf8mb4                          |
| character_set_system     | utf8mb3                          |
| character_sets_dir       | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.02 sec)

至此，就完成了在RockyLinux9上面安装和运行MySQL8

此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。原文来自 — 版权归原作者所有。

推荐订阅源

Liu Zijian's Blog | 一个技术博客

1.下载

2.编译安装前准备

3.编译安装

4.安装后配置

5.启动和测试MySQL Server