MySQL：CentOS 7 源码编译安装MySQL 5.7.32

CentOS 7 源码编译安装MySQL 5.7.32

• 下载源码包
  直接去官网下载就行：https://downloads.mysql.com/archives/community/
  
  如果安装的MySQL5.7及以上的版本，在编译安装之前需要安装boost,因为高版本mysql需要boots库的安装才可以正常运行。
  否则会报CMake Error at cmake/boost.cmake:81错误。
  直接下载带boost的包。
• 环境准备
  下面的安装采用的目录全部都是自定义的
  创建自定义目录

[root@docker-1 opt]# mkdir -p /opt/mysql/{config,dbdata,mysqllog/{binlog,logfile,relay-log},mysqltmp,product,redolog}

添加系统用户mysql，不创建家目录，并无法登录

[root@docker-1 opt]# useradd -s /sbin/nologin -M -r mysql

赋予权限

[root@docker-1 opt]# chown -R mysql.mysql /opt/mysql/

制作软连接

[root@docker-1 opt]# ln -s /opt/mysql /mysql

安装依赖环境

[root@docker-1 packages]# ls
bison-3.0.4-2.el7.x86_64.rpm                    keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm  libstdc++-4.8.5-44.el7.x86_64.rpm
cmake-2.8.12.2-2.el7.x86_64.rpm                 krb5-devel-1.15.1-50.el7.x86_64.rpm         libstdc++-devel-4.8.5-44.el7.x86_64.rpm
cpp-4.8.5-44.el7.x86_64.rpm                     krb5-libs-1.15.1-50.el7.x86_64.rpm          libverto-devel-0.2.5-4.el7.x86_64.rpm
e2fsprogs-1.42.9-19.el7.x86_64.rpm              libcom_err-1.42.9-19.el7.x86_64.rpm         m4-1.4.16-10.el7.x86_64.rpm
e2fsprogs-libs-1.42.9-19.el7.x86_64.rpm         libcom_err-devel-1.42.9-19.el7.x86_64.rpm   mpfr-3.1.1-4.el7.x86_64.rpm
gcc-4.8.5-44.el7.x86_64.rpm                     libgcc-4.8.5-44.el7.x86_64.rpm              ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm
gcc-c++-4.8.5-44.el7.x86_64.rpm                 libgomp-4.8.5-44.el7.x86_64.rpm             openssl-1.0.2k-21.el7_9.x86_64.rpm
glibc-2.17-323.el7_9.x86_64.rpm                 libkadm5-1.15.1-50.el7.x86_64.rpm           openssl-devel-1.0.2k-21.el7_9.x86_64.rpm
glibc-common-2.17-323.el7_9.x86_64.rpm          libmpc-1.0.1-3.el7.x86_64.rpm               openssl-libs-1.0.2k-21.el7_9.x86_64.rpm
glibc-devel-2.17-323.el7_9.x86_64.rpm           libselinux-devel-2.5-15.el7.x86_64.rpm      pcre-devel-8.32-17.el7.x86_64.rpm
glibc-headers-2.17-323.el7_9.x86_64.rpm         libsepol-devel-2.5-10.el7.x86_64.rpm        zlib-1.2.7-19.el7_9.x86_64.rpm
kernel-headers-3.10.0-1160.21.1.el7.x86_64.rpm  libss-1.42.9-19.el7.x86_64.rpm              zlib-devel-1.2.7-19.el7_9.x86_64.rpm
[root@docker-1 packages]# yum -y install *

我这里是离线安装，提前将rpm包下载好了，如果机器可以联网的话，可以直接按照下面命令安装。

yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make
yum -y install cmake

• 安装

解压安装包

[root@docker-1 opt]# tar xzvf mysql-boost-5.7.32.tar.gz -C /opt

编译

[root@docker-1 opt]# cd mysql-5.7.32/
[root@docker-1 mysql-5.7.32]# cmake . \
> -DWITH_BOOST=boost/boost_1_59_0/ \
> -DCMAKE_INSTALL_PREFIX=/opt/mysql/product/ \
> -DSYSCONFDIR=/opt/mysql/config/ \
> -DMYSQL_DATADIR=/opt/mysql/dbdata \
> -DINSTALL_MANDIR=/mysql/product/man \
> -DMYSQL_TCP_PORT=3306 \
> -DMYSQL_UNIX_ADDR=/mysql/dbdata/mysql.sock \
> -DDEFAULT_CHARSET=utf8 \
> -DEXTRA_CHARSETS=all \
> -DDEFAULT_COLLATION=utf8_general_ci \
> -DWITH_READLINE=1 \
> -DWITH_SSL=system \
> -DWITH_EMBEDDED_SERVER=1 \
> -DENABLED_LOCAL_INFILE=1 \
> -DWITH_INNOBASE_STORAGE_ENGINE=1

看到以下结果则编译成功

安装

[root@docker-1 mysql-5.7.32]# make -j 4
这里创建4个任务进行编译，加快速度，数字不要超过cpu核数的两倍，具体看机器情况

这需要大概半小时间，创建任务数越多，越快。

[root@docker-1 mysql-5.7.32]# make install

初始化

[root@docker-1 product]# ./bin/mysqld --initialize --user=mysql --basedir=/mysql/product/ --datadir=/mysql/dbdata
mysqld: [Warning] World-writable config file '/opt/mysql/config/my.cnf' is ignored.
2021-03-30T03:28:23.453946Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-30T03:28:25.302579Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-03-30T03:28:25.451343Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-03-30T03:28:25.507679Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: fcaf494b-9107-11eb-8a93-000c29ac07bb.
2021-03-30T03:28:25.508600Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-03-30T03:28:25.681220Z 0 [Warning] CA certificate ca.pem is self signed.
2021-03-30T03:28:25.793373Z 1 [Note] A temporary password is generated for root@localhost: C_dFgDIGr8=w
记住最后生成的初始化密码

启动服务

[root@docker-1 product]# ./bin/mysqld --defaults-file=/mysql/config/my.cnf --basedir=/mysql/product --datadir=/mysql/dbdata --plugin-dir=/mysql/product/lib/plugin --user=mysql --log-error=/mysql/mysqllog/logfile/mysql-err.log --open-files-limit=65535 --pid-file=mysqldb1.pid --socket=/mysql/dbdata/mysql.sock --port=3306
mysqld: [Warning] World-writable config file '/mysql/config/my.cnf' is ignored.

这是在前台运行，前台运行没有问题之后，再结束进程，改为后台服务。

修改密码

/opt/mysql/product/bin/mysqladmin -u root -p'C_dFgDIGr8=w' password '123'

安装成功

[root@docker-1 product]# ./bin/mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.32-log Source distribution

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

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.

root@mysqldb1 17:50:  [(none)]>