当前位置： 首页 > news >正文

MySQL8.0.40编译安装!

news 2026/5/12 14:55:40

近期MySQL发布了8.0.40版本，与之前的版本相比，部分依赖包发生了变化，因此重新编译一版，也便于大家参考。

1. 下载源码

选择对应的版本、选择源码、操作系统

如果没有登录或者没有MySQL官网账号，可以选择只下载

2. 进行编译

上传至机器，解压源码

tar -zxvf mysql-boost-8.0.40.tar.gz

2.1 准备阶段

因为编译安装需要cmake、make等命令，因此需提前安装相关依赖包及命令

yum install cmake make gcc gcc-c++ autoconf bison automake \openssl openssl-devel zlib* fiex* libxml* \ncurses-devel libmcrypt* libtool-ltdl-devel* -yyum install gcc-toolset-12-gcc gcc-toolset-12-gcc-c++ gcc-toolset-12-binu

tils gcc-toolset-12-annobin-annocheck gcc-toolset-12-annobin-plugin-gcc -y

由于MySQL从8.0.16版本开始，要求cmake的版本是cmake3以上，gcc版本为gcc 11.*以上版本，而且MySQL8.0.40的gcc需要12.*版本，因此如果使用Centos7等较低版本的操作系统，cmake及gcc g++版本较低，需要升级后才能编译。相关包升级附在文末

创建相关目录​​​​​​​

mkdir /usr/local/mysqlmkdir -p /data/mysql/mysql3306/{data,logs,tmp,etc}

2.2 编译检查阶段

开始编译​​​​​​​

cmake -DINSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql/mysql3306/data \-DMYSQL_UNIX_ADDR=/data/mysql/mysql3306/tmp/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_INNODB_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \-DFORCE_INSPECT=1 \-DCONNECT_WITH_SYSTEMD=OFF \-DDEFAULT_CHARSET=utf8mb4 \-DDEFAULT_COLLATION=utf8mb4_unicode_ci \-DWITH_BOOST=/usr/local/mysql-8.0.40/boost/boost_1_77_0 \-DENABLE_DOWNLOADS=1

出现报错​​​​​​​

-- Running cmake version 3.26.5-- This is .el9. as found from 'rpm -qf /'-- Looking for a devtoolset compiler-- Using /opt/rh/gcc-toolset-12/root/usr/bin/gcc-- Using /opt/rh/gcc-toolset-12/root/usr/bin/g++-- CMAKE_MODULE_PATH is /usr/local/mysql-8.0.40/cmake-- MySQL 8.0.40-- The C compiler identification is GNU 12.2.1-- The CXX compiler identification is GNU 12.2.1-- Detecting C compiler ABI info-- Detecting C compiler ABI info - done-- Check for working C compiler: /opt/rh/gcc-toolset-12/root/usr/bin/gcc - skipped-- Detecting C compile features-- Detecting C compile features - done-- Detecting CXX compiler ABI info-- Detecting CXX compiler ABI info - done-- Check for working CXX compiler: /opt/rh/gcc-toolset-12/root/usr/bin/g++ - skipped-- Detecting CXX compile features-- Detecting CXX compile features - done-- Source directory /usr/local/mysql-8.0.40-- Binary directory /usr/local/mysql-8.0.40CMake Error at CMakeLists.txt:642 (MESSAGE):Please do not build in-source. Out-of source builds are highlyrecommended: you can have multiple builds for the same source, and there isan easy way to do cleanup, simply remove the build directory (note that'make clean' or 'make distclean' does *not* work)You *can* force in-source build by invoking cmake with-DFORCE_INSOURCE_BUILD=1

因此加上 -DFORCE_INSOURCE_BUILD=1 再编译一次​​​​​​​

cmake -DINSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql/mysql3306/data \-DMYSQL_UNIX_ADDR=/data/mysql/mysql3306/tmp/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_INNODB_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \-DFORCE_INSPECT=1 \-DCONNECT_WITH_SYSTEMD=OFF \-DDEFAULT_CHARSET=utf8mb4 \-DDEFAULT_COLLATION=utf8mb4_unicode_ci \-DWITH_BOOST=/usr/local/mysql-8.0.40/boost/boost_1_77_0 \-DENABLE_DOWNLOADS=1 \-DFORCE_INSOURCE_BUILD=1

出现如下新报错信息​​​​​​​

CMake Error at cmake/readline.cmake:93 (MESSAGE):Curses library not found. Please install appropriate package,remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.Call Stack (most recent call first):cmake/readline.cmake:127 (FIND_CURSES)cmake/readline.cmake:221 (MYSQL_USE_BUNDLED_EDITLINE)CMakeLists.txt:1929 (MYSQL_CHECK_EDITLINE)-- Configuring incomplete, errors occurred!

缺少ncurses-devel依赖包所致，按照提示进行安装

yum install -y ncurses-devel*

再次编译出现新错误

缺少依赖，继续补充

yum install libtirpc* -y

安装后依旧报错（因为我的操作系统yum安装时没有libtirpc-devel），因此我选择查询出源码里的rpc.h文件，直接软连接到 /usr/include/ ，不建议这么操作，如果可以下载对应的安装包，建议安装依赖包​​​​​​​

find / -name rpc.h/usr/local/mysql-8.0.40/extra/libevent/libevent-2.1.11-stable/include/event2/rpc.h/usr/local/mysql-8.0.40/extra/tirpc/libtirpc-1.3.5/tirpc/rpc/rpc.h/usr/local/mysql-8.0.40/plugin/group_replication/libmysqlgcs/src/bindings/xcom/xcom/windeps/sunrpc/rpc/rpc.hln -s /usr/local/mysql-8.0.40/extra/tirpc/libtirpc-1.3.5/tirpc/rpc/rpc.h /usr/include/rpc/rpc.h

效果确实有效，继续进行编译，出现新问题：​​​​​​​

CMake Warning at cmake/rpc.cmake:30 (MESSAGE):Cannot find rpcgen executable. You need to install the required packages:Debian/Ubuntu: apt install rpcsvc-protoRedHat/Fedora/Oracle Linux: yum install rpcgenSuSE: zypper install glibc-develCall Stack (most recent call first):plugin/group_replication/libmysqlgcs/cmake/rpcgen.cmake:113 (WARN_MISSING_RPCGEN_EXECUTABLE)plugin/group_replication/libmysqlgcs/CMakeLists.txt:51 (INCLUDE)CMake Error at plugin/group_replication/libmysqlgcs/cmake/rpcgen.cmake:114 (MESSAGE):Could not find rpcgenCall Stack (most recent call first):plugin/group_replication/libmysqlgcs/CMakeLists.txt:51 (INCLUDE)

继续安装依赖包

yum install glibc-devel rpcgen -y

直至build完成

2.3 进行编译及安装

开始make进行编译，为了加快点速度，我启用2个核心进行编译

make -j 2

编译过程中出现新问题​​​​​​​

/usr/include/rpc/rpc.h:38:10: fatal error: rpc/types.h: No such file or directory38 | #include <rpc/types.h> /* some typedefs */| ^~~~~~~~~~~~~compilation terminated.make[2]: *** [plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/build.make:99: plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/src/bindings/xcom/xcom/pax_msg.cc.o] Error 1make[1]: *** [CMakeFiles/Makefile2:14468: plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/all] Error 2make[1]: *** Waiting for unfinished jobs....[ 14%] Built target oci_common_objlibmake: *** [Makefile:166: all] Error 2

主要是前面的rpc依赖处理所致，因此将rpc目录下所有文件都拷贝进来​​​​​​​

cp -rp /usr/local/mysql-8.0.40/extra/tirpc/libtirpc-1.3.5/tirpc/rpc /usr/include/rpcIn file included from /usr/include/rpc/rpc.h:38,from /usr/local/mysql-8.0.40/plugin/group_replication/libmysqlgcs/src/bindings/xcom/xcom/pax_msg.cc:28:/usr/include/rpc/types.h:98:10: fatal error: netconfig.h: No such file or directory98 | #include <netconfig.h>| ^~~~~~~~~~~~~compilation terminated.make[2]: *** [plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/build.make:99: plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/src/bindings/xcom/xcom/pax_msg.cc.o] Error 1make[1]: *** [CMakeFiles/Makefile2:14468: plugin/group_replication/libmysqlgcs/CMakeFiles/mysqlgcs.dir/all] Error 2make[1]: *** Waiting for unfinished jobs....[ 15%] Linking CXX static library librpl_channel_credentials_lib.a[ 15%] Built target rpl_channel_credentials_libmake: *** [Makefile:166: all] Error 2

继续复制依赖文件​​​​​​​

cp -rp /usr/local/mysql-8.0.40/extra/tirpc/libtirpc-1.3.5/tirpc/netconfig.h /usr/include/

完成后顺利进行编译。出现如下信息：

继续进行make install

make install

完成后结果如下

编译后MySQL内容如下

3. 安装数据库

创建数据库相关目录及配置文件

mkdir -p /data/mysql/mysql3306/{data,logs,tmp,etc}

配置文件按需添加放在etc/my.cnf中

创建mysql用户并将数据库目录授权​​​​​​​

useradd mysqlchown -R mysql:mysql /data/mysql/

初始化数据库​​​​​​​

cd /usr/local/mysqlbin/mysqld --defaults-file=/data/mysql/mysql3306/etc/my.cnf --initialize --user=mysql

如果无异常，则在数据库日志中可以查看初始化的root@localhost账号密码

登录数据库并修改密码

4. 补充部分依赖安装问题

4.1 cmake3

centos7系统中cmake预装版本较低，而编译8.0.40时需要更cmake3版本，如果无法通过yum install安装时，需要自己下载安装包进行安装

例如我在Centos7系统上用的3.15.5版本，可以通过如下命令下载

wget https://down.24kplus.com/linux/cmake/cmake-3.15.5.tar.gz

再解压、编译、安装即可​​​​​​​

wget https://down.24kplus.com/linux/cmake/cmake-3.15.5.tar.gztar -zxvf cmake-3.15.5.tar.gzcd cmake-3.15.5./bootstrap --prefix=/usr --datadir=share/cmake --docdir=doc/cmake && makemake install

完成后检查cmake版本

4.2 gcc

对于gcc版本，MySQL8.0.40之前gcc11即可，8.0.40版本开始需要gcc12,如果可以yum方式直接安装比较方便，如果不能则需要临时调整到高版本yum源进行安装或下载安装包进行安装。本次使用的调整yum源的方式，步骤如下：​​​​​​​

yum install scl-utilsyum install centos-release-scl centos-release-scl-rh

修改配置文件

vim /etc/yum.repos.d/CentOS-SCLo-scl.repo

添加如下内容​​​​​​​

[centos-sclo-sclo]name=CentOS-7 - SCLo sclobaseurl=https://mirrors.aliyun.com/centos-vault/7.9.2009/sclo/$basearch/sclo/gpgcheck=1enabled=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-sclo-testing]name=CentOS-7 - SCLo sclo Testingbaseurl=http://buildlogs.centos.org/centos/7/sclo/$basearch/sclo/gpgcheck=0enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-sclo-source]name=CentOS-7 - SCLo sclo Sourcesbaseurl=http://vault.centos.org/centos/7/sclo/Source/sclo/gpgcheck=1enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-sclo-debuginfo]name=CentOS-7 - SCLo sclo Debuginfobaseurl=http://debuginfo.centos.org/centos/7/sclo/$basearch/gpgcheck=1enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo

再添加repo文件

vim /etc/yum.repos.d/CentOS-SCLo-scl-rh.repo

添加如下内容​​​​​​​

# CentOS-SCLo-rh.repo## Please see http://wiki.centos.org/SpecialInterestGroup/SCLo for more# information[centos-sclo-rh]name=CentOS-7 - SCLo rhbaseurl=https://mirrors.aliyun.com/centos-vault/7.9.2009/sclo/$basearch/rh/# mirrorlist=http://mirrorlist.centos.org?arch=$basearch&release=7&repo=sclo-rhgpgcheck=1enabled=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-rh-testing]name=CentOS-7 - SCLo rh Testingbaseurl=http://buildlogs.centos.org/centos/7/sclo/$basearch/rh/gpgcheck=0enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-rh-source]name=CentOS-7 - SCLo rh Sourcesbaseurl=http://vault.centos.org/centos/7/sclo/Source/rh/gpgcheck=1enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo[centos-sclo-rh-debuginfo]name=CentOS-7 - SCLo rh Debuginfobaseurl=http://debuginfo.centos.org/centos/7/sclo/$basearch/gpgcheck=1enabled=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-SCLo

重建yum元数据缓存​​​​​​​

yum clean allyum makecache

安装gcc g++​​​​​​​

yum install devtoolset-11-gcc devtoolset-11-gcc-c++ devtoolset-11-binutils -y

4.3 libtirpc-devel

由于在Roky9上直接yum方式无libtirpc-devel包，因此手动下载安装包进行安装。需要用和libtirpc版本一致的，如果不一致，则缺少依赖。因此我直接将2个包都下载并安装​​​​​​​

wget http://rpmfind.net/linux/centos-stream/9-stream/BaseOS/x86_64/os/Packages/libtirpc-1.3.3-9.el9.x86_64.rpmwget https://mirrors.tuna.tsinghua.edu.cn/centos-stream/9-stream/CRB/x86_64/os/Packages/libtirpc-devel-1.3.3-6.el9.x86_64.rpm
再本地安装​​​​​​​
yum localinstall libtirpc-1.3.3-9.el9.x86_64.rpmyum localinstall -y libtirpc-devel-1.3.3-9.el9.x86_64.rpm

4.4 重新构建及编译

由于我在构建和编译过程中有的包不存在或版本不对应，因此进行过一次重编译，及cmake时添加fresh选项​​​​​​​

cmake --fresh -DINSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql/mysql3306/data \-DMYSQL_UNIX_ADDR=/data/mysql/mysql3306/tmp/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_INNODB_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all \-DFORCE_INSPECT=1 \-DCONNECT_WITH_SYSTEMD=OFF \-DDEFAULT_CHARSET=utf8mb4 \-DDEFAULT_COLLATION=utf8mb4_unicode_ci \-DWITH_BOOST=/usr/local/mysql-8.0.40/boost/boost_1_77_0 \-DENABLE_DOWNLOADS=1 \-DFORCE_INSOURCE_BUILD=1
http://www.jsqmd.com/news/191936/

相关文章：

  • 2025年靠谱高压加氢反应釜排行榜，高性价比立式反应釜公司推荐 - 工业品网
  • HoRain云--OpenCV图像阈值处理全解析
  • HeyGem v1.0版本发布：数字人视频生成进入平民化时代
  • 2025年度杭州西湖龙井团购专属茶叶门店推荐：知名的西湖龙井茶店 - 工业推荐榜
  • 2026年行业内优质的铝合金衬PB复合管厂商怎么选，PERT铝合金衬塑复合管、PPR铝合金衬塑复合管定制厂家推荐排行榜单 - 品牌推荐师
  • 批量生成AI数字人视频？试试HeyGem WebUI版本的强大功能
  • GEE进行地表光谱反射率曲线分析
  • 【Dubbo】接口本地调试
  • 低成本解锁 Claude Code：程序员必备的高性价比使用指南 - poloapi-ai大模型
  • C#指针编程避坑指南：using别名在unsafe代码中的妙用（仅限高手）
  • C语言 类型转换易错点（一）
  • 2026年市场好用的铝合金衬塑复合管订制厂家推荐排行榜，PERT铝合金衬塑复合管、PPR铝合金衬塑复合管制造厂哪家靠谱 - 品牌推荐师
  • 【好写作AI】你的论文救命神器？NLP黑科技如何把“学术垃圾”变废为宝！
  • 【好写作AI】你的论文，真的是AI“亲生”的吗？解密深度学习的学术文本制造局
  • 对线面试官系列：MySQL 执行流程，清晰易懂！
  • 为什么选择HeyGem而不是其他数字人方案？五大优势分析
  • 【好写作AI】当写作变成“弹幕互动”：你的论文，正在被AI实时“吐槽”
  • 韩国电信诈骗“无过错赔偿”制度的立法逻辑与技术应对路径
  • 播放按钮在哪里？HeyGem允许预览原始音频和最终视频
  • 为什么顶尖开发者都在用C# using别名管理复杂指针类型？
  • 2026年 钢结构/路基箱/钢梁/激光切割/预埋件厂家权威推荐榜：实力工厂与创新工艺深度解析 - 品牌企业推荐师（官方）
  • [特殊字符]️删除当前视频功能：精准移除不需要的生成结果
  • 2026国内网站建设公司推荐哪家好？设计到技术及综合型3大阵营供应商精准选型指南 - 资讯焦点
  • 本地化部署保障隐私：HeyGem让你的数据不出内网
  • 为什么顶尖团队都在用C#内联数组？深度解析其底层加速原理
  • 【SPIE出版 | EI检索】2026进化算法和智能控制国际研讨会（ISEAIC 2026）
  • OpenCV是否参与HeyGem人脸检测与对齐过程？
  • 技术日报｜Python ETL框架Pathway日增1219星登顶GitHub
  • 10351_基于Springboot的二手交易平台
  • 【C#高效编程核心技能】：Lambda多参数传递的4种高级模式