Linux使用源码安装MySQL
有两种方法来使用源码安装MySQL:
.使用一种标准的MySQL源码安装。标准的可用源码文件被压缩成tar文件，zip文件或RPM包。文件名的格式为mysql-version.tar.gz,mysql-version.zip或mysql-version.rpm。其中version是版本号比例如5.7.25。发布的源码文件名与预先编译好的二进制文件名是有区别的，源码文件名通常不包含平台名，而二进制文件名包含平台名，例如pc-linux-i686或winx64。
.使用MySQL开发树。如何构建开发树将在使用开发源码树来安装MySQL中进行介绍。
使用源码安装MySQL操作系统所要满足的条件
使用源码来安装MySQL需要几个开发工具。无论您使用的是标准的源代码分发版还是开发源代码树，都需要这些工具中的一部分。是否需要其它工具依赖于你的安装方法。
为了使用源码来安装MySQL，不管使用何种安装方法下面的要求必须要满足:
.CMake，用来在所有平台上构建框架，可以从http://www.cmake.org来下载CMake。
.一个好的make程序，虽然一些平台有它们自己的make实现，但强烈建议使用GNU make 3.75或更高版本。它可能已经存在于你的系统中了gmake。可以从http://www.gnu.org/software/make/下载GNU make。
.ANSI C++编译器。可以对force_unsupported_compiler的描述。
.为了构建MySQL需要Boost C++库(但不使用它)。Boost 1.59.0必须被安装。为了获得Boost与它的安装指令，可以访问https://www.boost.org/网址。在Boost安装后，当调用CMake时通过使用WITH_BOOST选项来告诉构建系统在哪里定位Boost文件。
shell>cmake . -DWITH_BOOST=/usr/local/boost_1_59_0
根据实际情况来调整路径。
.ncurses库 https://www.gnu.org/software/ncurses/ncurses.html
.足够的空闲内存。当编译很大的源文件时如果遇到了”internal compiler error”错误，那么可能是因为你没有足够的内存。如果在一个虚拟机上进行编译，尝试增加内存分配。
.如果你希望运行测试脚本那么就需要安装perl。大多数像Unix的系统已经包含了perl。在windows上可以使用ActiveState Perl。
为了使用标准的源码发布版本来安装MySQL，需要以下一种工具来解压发布的源码文件:
.对于一个.tar.gz的压缩tar文件，GNU gunzip可以用来解压tar用来unpack。如果你的tar程序支持z选项，它可以用来解压与 unpack文件。GNU tar众所周知是有效的。一些操作系统提供的标准tar不能对MySQL发布版本的长文件名进行unpack操作。你应该安装GUN tar或者可能的话，使用预安装版本的GNU tar。常用的有gnutar,gtar,tar或者自由软件目录，比如/usr/sfw/bin或/usr/local/bin。GNU tar可以从http://www.gnu.org/software/tar/进行下载。
.对于一个.zip归档文件，winzip或另外的工具可以读取.zip文件。
.对于一个.rpm的RPM包，rpmbuild程序用来对构建的发布版本进行unpack操作。
为了使用开发源码树来安装MySQL，需要安装以下额外的工具:
.需要Git版本控制系统来获得开发源代码。https://help.github.com/en提供了指令在不同平台上下载与安装Git。MySQL官方组织已经于2014年9月加入了GitHub。
.bison 2.1或更高版本，可以从http://www.gnu.org/software/bison/网址进行下载(1版本不再支持)，尽可能的使用最新版本，如果你遇到了问题，那么升级到最新的版本，而不是回退到更早的版本。
bison可以从http://www.gnu.org/software/bison/网址进行下载，对于Windows平台可以从http://gnuwin32.sourceforge.net/packages/bison.htm网址进行下载。在Windows平台上，bison的缺省目录是C:\Program Files\GnuWin32目录。有一些工具可以在查找bison会失败，因为在目录名中存在空隔。同样,Visual Studio如果在路径中存在空隔可能会出现hang住。为了解决这种问题的出现，可以将bison安装到C:\GnuWin32目录。
.在Solaris平台上,除了bison之外m4必须被安装。m4可以从http://www.gnu.org/software/m4/网址下载。
注意在安装任何程序之后，需要修改你的PATH环境变量来包含定位程序的目录。
源码安装MySQL的布局
缺省情况下，当使用源码编译后安装MySQL，安装操作会将文件安装在/usr/local/mysql目录中。这与使用二进制文件安装的安装目录是一样的。
使用标准源码安装MySQL
1.安装所需要的工具包
[root@localhost ~]# yum -y install gcc* gcc-c++ ncurses* ncurses-devel* cmake* bison* libgcrypt* perl* make* ....... 已安装: gcc-gnat.x86_64 0:4.8.5-36.0.1.el7 gcc-objc.x86_64 0:4.8.5-36.0.1.el7 gcc-objc++.x86_64 0:4.8.5-36.0.1.el7 libgcrypt-devel.x86_64 0:1.5.3-14.el7 ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 ncurses-term.noarch 0:5.9-14.20130511.el7_4 perl-Algorithm-Diff.noarch 0:1.1902-17.el7 perl-App-cpanminus.noarch 0:1.6922-2.el7 perl-Archive-Extract.noarch 1:0.68-3.el7 perl-Archive-Zip.noarch 0:1.30-11.el7 perl-Authen-SASL.noarch 0:2.15-10.el7 perl-B-Lint.noarch 0:1.17-3.el7 perl-Bit-Vector.x86_64 0:7.3-3.el7 perl-CGI.noarch 0:3.63-4.el7 perl-CGI-Session.noarch 0:4.35-16.el7 perl-CPAN.noarch 0:1.9800-293.el7 perl-CPAN-Meta.noarch 0:2.120921-5.el7 perl-CPAN-Meta-Requirements.noarch 0:2.122-7.el7 perl-CPAN-Meta-YAML.noarch 0:0.008-14.el7 perl-CPANPLUS.noarch 0:0.91.38-4.el7 perl-CPANPLUS-Dist-Build.noarch 0:0.70-3.el7 perl-Carp-Clan.noarch 0:6.04-10.el7 perl-Class-ISA.noarch 0:0.36-1010.el7 perl-Class-Load.noarch 0:0.20-3.el7 perl-Class-Singleton.noarch 0:1.4-14.el7 perl-Convert-ASN1.noarch 0:0.26-4.el7 perl-DBD-MySQL.x86_64 0:4.023-6.0.1.el7 perl-DBD-Pg.x86_64 0:2.19.3-4.el7 perl-DBIx-Simple.noarch 0:1.35-7.el7 perl-Data-OptList.noarch 0:0.107-9.el7 perl-Date-Calc.noarch 0:6.3-14.el7 perl-Date-Manip.noarch 0:6.41-2.el7 perl-DateTime.x86_64 2:1.04-6.el7 perl-DateTime-Format-DateParse.noarch 0:0.05-5.el7 perl-DateTime-Locale.noarch 0:0.45-6.el7 perl-DateTime-TimeZone.noarch 0:1.70-1.el7 perl-Devel-Symdump.noarch 1:2.10-2.el7 perl-Digest-SHA1.x86_64 0:2.13-9.el7 perl-Env.noarch 0:1.04-2.el7 perl-ExtUtils-CBuilder.noarch 1:0.28.2.6-293.el7 perl-ExtUtils-Embed.noarch 0:1.30-293.el7 perl-FCGI.x86_64 1:0.74-8.el7 perl-File-CheckTree.noarch 0:4.42-3.el7 perl-File-Fetch.noarch 0:0.42-2.el7 perl-Font-AFM.noarch 0:1.20-13.el7 perl-FreezeThaw.noarch 0:0.5001-10.el7 perl-GD.x86_64 0:2.49-3.el7 perl-GSSAPI.x86_64 0:0.28-9.el7 perl-HTML-Format.noarch 0:2.10-7.el7 perl-HTML-Tree.noarch 1:5.03-2.el7 perl-IO-stringy.noarch 0:2.110-22.el7 perl-IPC-Cmd.noarch 1:0.80-4.el7 perl-JSON.noarch 0:2.59-2.el7 perl-JSON-PP.noarch 0:2.27202-2.el7 perl-LDAP.noarch 1:0.56-6.el7 perl-LWP-Protocol-https.noarch 0:6.04-4.el7 perl-List-MoreUtils.x86_64 0:0.33-9.el7 perl-Locale-Codes.noarch 0:3.26-2.el7 perl-Locale-Maketext.noarch 0:1.23-3.el7 perl-Locale-Maketext-Simple.noarch 1:0.21-293.el7 perl-Log-Message.noarch 1:0.08-3.el7 perl-Log-Message-Simple.noarch 0:0.10-2.el7 perl-Module-Build.noarch 2:0.40.05-2.el7 perl-Module-CoreList.noarch 1:2.76.02-293.el7 perl-Module-Implementation.noarch 0:0.06-6.el7 perl-Module-Load.noarch 1:0.24-3.el7 perl-Module-Load-Conditional.noarch 0:0.54-3.el7 perl-Module-Loaded.noarch 1:0.08-293.el7 perl-Module-Metadata.noarch 0:1.000018-2.el7 perl-Module-Pluggable.noarch 1:4.8-3.el7 perl-Module-Runtime.noarch 0:0.013-4.el7 perl-Module-Signature.noarch 0:0.73-2.el7 perl-Mozilla-CA.noarch 0:20130114-5.el7 perl-Newt.x86_64 0:1.08-36.el7 perl-Object-Accessor.noarch 1:0.42-293.el7 perl-PAR-Dist.noarch 0:0.49-2.el7 perl-Package-DeprecationManager.noarch 0:0.13-7.el7 perl-Package-Stash.noarch 0:0.34-2.el7 perl-Package-Stash-XS.x86_64 0:0.26-3.el7 perl-Params-Check.noarch 1:0.38-2.el7 perl-Params-Util.x86_64 0:1.07-6.el7 perl-Params-Validate.x86_64 0:1.08-4.el7 perl-Parse-CPAN-Meta.noarch 1:1.4404-5.el7 perl-Perl-OSType.noarch 0:1.003-3.el7 perl-Perl4-CoreLibs.noarch 0:0.003-7.el7 perl-Pod-Checker.noarch 0:1.60-2.el7 perl-Pod-Coverage.noarch 0:0.23-3.el7 perl-Pod-LaTeX.noarch 0:0.61-2.el7 perl-Pod-Parser.noarch 0:1.61-2.el7 perl-Pod-Plainer.noarch 0:1.03-4.el7 perl-SGMLSpm.noarch 0:1.03ii-31.el7 perl-SNMP_Session.noarch 0:1.13-5.el7 perl-String-ShellQuote.noarch 0:1.04-10.el7 perl-Sub-Install.noarch 0:0.926-6.el7 perl-Sys-CPU.x86_64 0:0.54-4.el7 perl-Sys-Guestfs.x86_64 1:1.38.2-12.0.1.el7 perl-Sys-MemInfo.x86_64 0:0.91-7.el7 perl-Sys-Virt.x86_64 0:4.5.0-2.el7 perl-Term-UI.noarch 0:0.36-2.el7 perl-Test-Pod.noarch 0:1.48-3.el7 perl-Test-Pod-Coverage.noarch 0:1.08-21.el7 perl-Test-Simple.noarch 0:0.98-243.el7 perl-Text-Diff.noarch 0:1.41-5.el7 perl-Text-Soundex.x86_64 0:3.04-4.el7 perl-Text-Unidecode.noarch 0:0.04-20.el7 perl-Time-Piece.x86_64 0:1.20.1-293.el7 perl-Try-Tiny.noarch 0:0.12-2.el7 perl-Version-Requirements.noarch 0:0.101022-244.el7 perl-XML-Dumper.noarch 0:0.81-17.el7 perl-XML-Filter-BufferText.noarch 0:1.01-17.el7 perl-XML-Grove.noarch 0:0.46alpha-52.el7 perl-XML-SAX-Writer.noarch 0:0.53-4.el7 perl-XML-Twig.noarch 0:3.44-2.el7 perl-XML-Writer.noarch 0:0.623-3.el7 perl-XML-XPath.noarch 0:1.13-22.el7 perl-YAML.noarch 0:0.84-5.el7 perl-YAML-Tiny.noarch 0:1.51-6.el7 perl-autodie.noarch 0:2.16-2.el7 perl-core.x86_64 0:5.16.3-293.el7 perl-gettext.x86_64 0:1.05-28.el7 perl-homedir.noarch 0:1.008010-4.el7 perl-libintl.x86_64 0:1.20-12.el7 perl-libxml-perl.noarch 0:0.08-19.el7 perl-local-lib.noarch 0:1.008010-4.el7 perltidy.noarch 0:20121207-3.el7 作为依赖被安装: glusterfs-cli.x86_64 0:3.12.2-18.el7 glusterfs-client-xlators.x86_64 0:3.12.2-18.el7 libgnat.x86_64 0:4.8.5-36.0.1.el7 libgnat-devel.x86_64 0:4.8.5-36.0.1.el7 libgpg-error-devel.x86_64 0:1.12-3.el7 libobjc.x86_64 0:4.8.5-36.0.1.el7 libvirt-bash-completion.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-core.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-disk.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-gluster.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-iscsi.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-logical.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-mpath.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-rbd.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage-scsi.x86_64 0:4.5.0-10.el7 libvirt-libs.x86_64 0:4.5.0-10.el7 openjade.x86_64 0:1.3.2-45.el7 opensp.x86_64 0:1.5.2-19.el7 pcp-selinux.x86_64 0:4.1.0-4.el7 postgresql-libs.x86_64 0:9.2.24-1.el7_5 squashfs-tools.x86_64 0:4.3-0.21.gitaae0aff4.el7 更新完毕: bison.x86_64 0:3.0.4-2.el7 gcc.x86_64 0:4.8.5-36.0.1.el7 gcc-c++.x86_64 0:4.8.5-36.0.1.el7 gcc-gfortran.x86_64 0:4.8.5-36.0.1.el7 libgcrypt.x86_64 0:1.5.3-14.el7 make.x86_64 1:3.82-23.el7 ncurses.x86_64 0:5.9-14.20130511.el7_4 ncurses-base.noarch 0:5.9-14.20130511.el7_4 ncurses-libs.x86_64 0:5.9-14.20130511.el7_4 perl.x86_64 4:5.16.3-293.el7 perl-Digest-SHA.x86_64 1:5.85-4.el7 perl-ExtUtils-Install.noarch 0:1.58-293.el7 perl-ExtUtils-ParseXS.noarch 1:3.18-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7 perl-Git.noarch 0:1.8.3.1-19.el7 perl-HTTP-Daemon.noarch 0:6.01-8.el7 perl-IO-Socket-IP.noarch 0:0.21-5.el7 perl-IO-Socket-SSL.noarch 0:1.94-7.el7 perl-IO-Zlib.noarch 1:1.10-293.el7 perl-Net-DNS.x86_64 0:0.72-6.el7 perl-Net-SSLeay.x86_64 0:1.55-6.el7 perl-PCP-PMDA.x86_64 0:4.1.0-4.el7 perl-Package-Constants.noarch 1:0.02-293.el7 perl-Pod-Escapes.noarch 1:1.04-293.el7 perl-Socket.x86_64 0:2.010-4.el7 perl-Test-Harness.noarch 0:3.28-3.el7 perl-devel.x86_64 4:5.16.3-293.el7 perl-hivex.x86_64 0:1.3.10-6.9.el7 perl-libs.x86_64 4:5.16.3-293.el7 perl-macros.x86_64 4:5.16.3-293.el7 perl-version.x86_64 3:0.99.07-3.el7 作为依赖被升级: cpp.x86_64 0:4.8.5-36.0.1.el7 git.x86_64 0:1.8.3.1-19.el7 glusterfs.x86_64 0:3.12.2-18.el7 glusterfs-api.x86_64 0:3.12.2-18.el7 glusterfs-fuse.x86_64 0:3.12.2-18.el7 glusterfs-libs.x86_64 0:3.12.2-18.el7 glusterfs-rdma.x86_64 0:3.12.2-18.el7 hivex.x86_64 0:1.3.10-6.9.el7 libgcc.x86_64 0:4.8.5-36.0.1.el7 libgfortran.x86_64 0:4.8.5-36.0.1.el7 libgomp.x86_64 0:4.8.5-36.0.1.el7 libguestfs.x86_64 1:1.38.2-12.0.1.el7 libquadmath.x86_64 0:4.8.5-36.0.1.el7 libquadmath-devel.x86_64 0:4.8.5-36.0.1.el7 libstdc++.x86_64 0:4.8.5-36.0.1.el7 libstdc++-devel.x86_64 0:4.8.5-36.0.1.el7 libvirt.x86_64 0:4.5.0-10.el7 libvirt-client.x86_64 0:4.5.0-10.el7 libvirt-daemon.x86_64 0:4.5.0-10.el7 libvirt-daemon-config-network.x86_64 0:4.5.0-10.el7 libvirt-daemon-config-nwfilter.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-interface.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-lxc.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-network.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-nodedev.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-nwfilter.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-qemu.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-secret.x86_64 0:4.5.0-10.el7 libvirt-daemon-driver-storage.x86_64 0:4.5.0-10.el7 libvirt-daemon-kvm.x86_64 0:4.5.0-10.el7 openssl.x86_64 1:1.0.2k-16.0.1.el7 openssl-libs.x86_64 1:1.0.2k-16.0.1.el7 pcp.x86_64 0:4.1.0-4.el7 pcp-conf.x86_64 0:4.1.0-4.el7 pcp-libs.x86_64 0:4.1.0-4.el7 python-pcp.x86_64 0:4.1.0-4.el7 supermin5.x86_64 0:5.1.19-1.el7 完毕！
2.使用命令检查是否安装有MySQL Server包
[root@localhost ~]# rpm -qa | grep mysql [root@localhost ~]# rpm -aq | grep mysql mysql-community-libs-5.6.23-3.el7.x86_64 qt-mysql-4.8.5-8.0.1.el7.x86_64 akonadi-mysql-1.9.2-4.0.1.el7.x86_64 mysql-community-common-5.6.23-3.el7.x86_64 mysql-community-server-5.6.23-3.el7.x86_64 mysql-community-client-5.6.23-3.el7.x86_64
删除操作有以下两种
rpm -e mysql-libs //普通删除模式
rpm -e –nodeps mysql-lib// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除
[root@localhost ~]# rpm -e --nodeps mysql-community-libs [root@localhost ~]# rpm -e --nodeps akonadi-mysql [root@localhost ~]# rpm -e --nodeps mysql-community-common [root@localhost ~]# rpm -e --nodeps mysql-community-server [root@localhost ~]# rpm -e --nodeps mysql-community-client [root@localhost ~]# rpm -e --nodeps qt-mysql [root@localhost ~]# rpm -aq | grep mysql
3.下载源码文件mysql-5.7.26.tar.gz并上传到服务器的/soft目录中
[root@localhost soft]# ls -lrt 总用量 79960 -rw-r--r--. 1 root root 54056899 5月 30 16:36 mysql-5.7.26.tar.gz
4.下载boost包并上传到服务器的/soft目录中
5. 创建mysql用户与用户组
[root@localhost /]# groupadd mysql [root@localhost /]# useradd -r -g mysql -s /bin/false mysql
因为用户只用于所有权目的，而不是登录目的，useradd命令使用-r与-s /bin/false选项来创建一个用户没有登录服务器主机的权限。
6.创建并修改/mysqlsoft/mysql与/mysqldata/mysql目录权限
[root@localhost /]# mkdir -p /mysqlsoft/mysql [root@localhost /]# mkdir -p /mysqldata/mysql [root@localhost /]# chown -R mysql:mysql /mysqlsoft [root@localhost /]# chown -R mysql:mysql /mysqldata/mysql [root@localhost /]# chmod -R 775 /mysqlsoft/mysql [root@localhost /]# chmod -R 775 /mysqldata/mysql
7.解压boost软件包与MySQL源码包
[root@localhost soft]# unzip boost_1_59_0.zip [root@localhost soft]# ls -lrt 总用量 201556 drwx------. 8 root root 4096 8月 12 2015 boost_1_59_0 -rw-r--r--. 1 root root 54056899 5月 30 16:36 mysql-5.7.26.tar.gz -rw-r--r--. 1 root root 124506259 6月 13 21:07 boost_1_59_0.zip
将MySQL文件解压到/soft目录下
[root@localhost soft]# tar zxvf mysql-5.7.26.tar.gz [root@localhost soft]# ls -lrt 总用量 201560 drwx------. 8 root root 4096 8月 12 2015 boost_1_59_0 drwxr-xr-x. 35 7161 31415 4096 4月 13 21:46 mysql-5.7.26 -rw-r--r--. 1 root root 54056899 5月 30 16:36 mysql-5.7.26.tar.gz -rw-r--r--. 1 root root 27816900 6月 10 11:32 docker-17.03.0-ce.tgz -rw-r--r--. 1 root root 124506259 6月 13 21:07 boost_1_59_0.zip 总用量 4 [root@localhost soft]# chown -R mysql:mysql mysql-5.7.26 [root@localhost soft]# chmod -R 775 mysql-5.7.26
8.预编译MySQL
[root@localhost soft]# su - mysql 上一次登录：一 6月 17 12:21:54 CST 2019pts/0 上 -bash-4.2$ cd /soft/mysql-5.7.26/ -bash-4.2$ cmake . -DCMAKE_INSTALL_PREFIX=/mysqlsoft/mysql \ > -DMYSQL_DATADIR=/mysqldata/mysql \ > -DMYSQL_UNIX_ADDR=/mysqlsoft/mysql/mysql.sock \ > -DWITH_BOOST=../boost_1_59_0 \ > -DWITH_INNOBASE_STORAGE_ENGINE=1 \ > -DWITH_PARTITION_STORAGE_ENGINE=1 \ > -DWITH_FEDERATED_STORAGE_ENGINE=1 \ > -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ > -DWITH_MYISAM_STORAGE_ENGINE=1 \ > -DENABLED_LOCAL_INFILE=1 \ > -DENABLE_DTRACE=0 \ > -DDEFAULT_CHARSET=utf8mb4 \ > -DDEFAULT_COLLATION=utf8mb4_general_ci \ > -DWITH_EMBEDDED_SERVER=1 .................... -- Found PkgConfig: /bin/pkg-config (found version "0.27.1") -- checking for module 'libtirpc' -- package 'libtirpc' not found -- Performing Test HAVE_STRUCT_SOCKADDR_SA_LEN -- Performing Test HAVE_STRUCT_SOCKADDR_SA_LEN - Failed -- Performing Test HAVE_STRUCT_IFREQ_IFR_NAME -- Performing Test HAVE_STRUCT_IFREQ_IFR_NAME - Success -- Performing Test HAVE_XDR_OPS_X_PUTINT32 -- Performing Test HAVE_XDR_OPS_X_PUTINT32 - Success -- Performing Test HAVE_XDR_OPS_X_GETINT32 -- Performing Test HAVE_XDR_OPS_X_GETINT32 - Success -- Performing Test HAVE___CONST -- Performing Test HAVE___CONST - Success -- Performing Test HAVE_RPC_INLINE_T -- Performing Test HAVE_RPC_INLINE_T - Failed -- Performing Test OLD_XDR -- Performing Test OLD_XDR - Failed -- Performing Test X_GETPOSTN_NOT_USE_CONST -- Performing Test X_GETPOSTN_NOT_USE_CONST - Success -- Performing Test HAS_INCOMPATIBLE_POINTER_TYPES -- Performing Test HAS_INCOMPATIBLE_POINTER_TYPES - Failed -- Performing Test X_PUTLONG_NOT_USE_CONST -- Performing Test X_PUTLONG_NOT_USE_CONST - Failed -- checking for module 'libtirpc' -- package 'libtirpc' not found -- RPC_INCLUDE_DIRS /usr/include -- Using Boost headers from /soft/boost_1_59_0 -- Performing Test CXX_HAVE_SIGN_COMPARE -- Performing Test CXX_HAVE_SIGN_COMPARE - Success -- Performing Test CXX_HAVE_UNUSED_VARIABLE -- Performing Test CXX_HAVE_UNUSED_VARIABLE - Success -- MYSQLX - Text log of protobuf messages enabled -- Performing Test HAVE_UNUSED_PARAMETER -- Performing Test HAVE_UNUSED_PARAMETER - Success -- Googletest was not found. gtest-based unit tests will be disabled. You can run cmake . -DENABLE_DOWNLOADS=1 to automatically download and build required components from source. -- If you are inside a firewall, you may need to use an https proxy: export https_proxy=http://example.com:80 -- Performing Test HAVE_MISLEADING_INDENTATION -- Performing Test HAVE_MISLEADING_INDENTATION - Failed -- executable target mysqld debug_target /soft/debug/sql/mysqld -- Library mysqlserver depends on OSLIBS -lpthread;m;rt;crypt;dl -- MERGE_CONVENIENCE_LIBRARIES TARGET mysqlserver -- MERGE_CONVENIENCE_LIBRARIES LIBS dbug;strings;regex;mysys;mysys_ssl;vio;zlib;yassl;taocrypt;crypt;dl;archive_embedded;blackhole_embedded;csv_embedded;federated_embedded;heap_embedded;innobase_embedded;lz4_lib;myisam_embedded;myisammrg_embedded;partition_embedded;ngram_parser_embedded;sql_embedded -- MERGE_CONVENIENCE_LIBRARIES MYLIBS dbug;strings;regex;mysys;mysys_ssl;vio;zlib;yassl;taocrypt;archive_embedded;blackhole_embedded;csv_embedded;federated_embedded;heap_embedded;innobase_embedded;lz4_lib;myisam_embedded;myisammrg_embedded;partition_embedded;ngram_parser_embedded;sql_embedded -- library target mysqlserver debug_target /soft/debug/archive_output_directory/libmysqld.a -- INSTALL mysqlclient.pc lib/pkgconfig -- Skipping deb packaging on unsupported platform . -- CMAKE_BUILD_TYPE: RelWithDebInfo -- COMPILE_DEFINITIONS: _GNU_SOURCE;_FILE_OFFSET_BITS=64;HAVE_CONFIG_H;HAVE_LIBEVENT2 -- CMAKE_C_FLAGS: -Wall -Wextra -Wformat-security -Wvla -Wwrite-strings -Wdeclaration-after-statement -- CMAKE_CXX_FLAGS: -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter -- CMAKE_C_LINK_FLAGS: -- CMAKE_CXX_LINK_FLAGS: -- CMAKE_C_FLAGS_RELWITHDEBINFO: -O3 -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -- CMAKE_CXX_FLAGS_RELWITHDEBINFO: -O3 -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -- Configuring done -- Generating done -- Build files have been written to: /soft/mysql-5.7.26
9.编译源码，这时使用-j 6选项来使用6个进程同时进行编译
-bash-4.2$ make -j 6 ......... Building CXX object sql/CMakeFiles/sql.dir/event_data_objects.cc.o Building CXX object sql/CMakeFiles/sql.dir/des_key_file.cc.o Building CXX object sql/CMakeFiles/sql.dir/event_db_repository.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/event_parse_data.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/event_queue.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/event_scheduler.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/events.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/mf_iocache.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/mysqld.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/mysqld_thd_manager.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/protocol_callback.cc.o [ 97%] Building CXX object sql/CMakeFiles/sql.dir/signal_handler.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/sql_audit.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/sql_client.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/srv_session.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/srv_session_info_service.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/srv_session_service.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/auth/sha2_password_common.cc.o [ 98%] Building CXX object sql/CMakeFiles/sql.dir/mysqld_daemon.cc.o Linking CXX static library ../archive_output_directory/libsql.a [ 98%] Built target sql Scanning dependencies of target mysqld Scanning dependencies of target pfs_connect_attr-t [ 99%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld [100%] [100%] [100%] Building CXX object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/__/__/__/sql/sql_builtin.cc.o Building CXX object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/pfs_connect_attr-t.cc.o Building C object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/__/__/__/mysys/string.c.o Linking CXX executable pfs_connect_attr-t [100%] Built target mysqld [100%] Built target pfs_connect_attr-t
10.安装
-bash-4.2$ make install ................. -- Installing: /mysqlsoft/mysql/mysql-test/./t/wl6661.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/wl6711_heap_to_disk.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/wl6978.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa_debug.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa_gtid-master.opt -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa_gtid.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa_prepared_binlog_off-master.opt -- Installing: /mysqlsoft/mysql/mysql-test/./t/xa_prepared_binlog_off.test -- Installing: /mysqlsoft/mysql/mysql-test/./t/xml.test -- Installing: /mysqlsoft/mysql/mysql-test/./valgrind.supp -- Installing: /mysqlsoft/mysql/mysql-test/./mtr -- Installing: /mysqlsoft/mysql/mysql-test/./mysql-test-run -- Installing: /mysqlsoft/mysql/mysql-test/./Makefile -- Installing: /mysqlsoft/mysql/mysql-test/./cmake_install.cmake -- Installing: /mysqlsoft/mysql/mysql-test/./CTestTestfile.cmake -- Installing: /mysqlsoft/mysql/./COPYING-test -- Installing: /mysqlsoft/mysql/./README-test -- Up-to-date: /mysqlsoft/mysql/mysql-test/mtr -- Up-to-date: /mysqlsoft/mysql/mysql-test/mysql-test-run -- Installing: /mysqlsoft/mysql/mysql-test/lib/My/SafeProcess/my_safe_process -- Up-to-date: /mysqlsoft/mysql/mysql-test/lib/My/SafeProcess/my_safe_process -- Installing: /mysqlsoft/mysql/mysql-test/lib/My/SafeProcess/Base.pm -- Installing: /mysqlsoft/mysql/support-files/mysqld_multi.server -- Installing: /mysqlsoft/mysql/support-files/mysql-log-rotate -- Installing: /mysqlsoft/mysql/support-files/magic -- Installing: /mysqlsoft/mysql/share/aclocal/mysql.m4 -- Installing: /mysqlsoft/mysql/support-files/mysql.server [root@localhost mysqlsoft]# chmod -R 775 mysql
11.配置mysql参数,只是设置几个简单的mysql运行参数
[root@localhost mysql]# vi /mysqlsoft/mysql/my.cnf [mysqld] basedir=/mysqlsoft/mysql datadir=/mysqldata/mysql bind-address=0.0.0.0 user=mysql port=3306 log-error=/mysqldata/mysql/mysql.err pid-file=/mysqldata/mysql/mysqld.pid socket = /mysqlsoft/mysql/mysql.sock character-set-server=utf8mb4 default-storage-engine=INNODB explicit_defaults_for_timestamp = true [root@localhost mysql]# cd bin [root@localhost bin]# ./mysqld --defaults-file=/mysqlsoft/mysql/my.cnf --initialize --basedir=/mysqlsoft/mysql --datadir=/mysqldata/mysql --user=mysql
查看日志信息
[root@localhost mysql]# tail -f mysql.err 2019-06-17T06:28:34.137849Z 0 [Warning] InnoDB: New log files created, LSN=45790 2019-06-17T06:28:35.342112Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2019-06-17T06:28:35.465187Z 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: 2296e390-90c9-11e9-9a9f-005056a390e6. 2019-06-17T06:28:35.471829Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2019-06-17T06:28:35.474533Z 1 [Note] A temporary password is generated for root@localhost: Ldp#HUPR(7hH
其中[Note] A temporary password is generated for root@localhost:后面跟的是mysql数据库登录的临时密码，各人安装生成的临时密码不一样。可以看到到日志文件没有报错，而且有了临时密码，表示初始化成功。
12.如果想服务能够部署自动支持安全连接，使用mysql_ssl_rsa_setup工具来创建缺省SSL与RSA文件
[root@localhost bin]# ./mysql_ssl_rsa_setup --datadir=/mysqldata/mysql Generating a 2048 bit RSA private key ...........................+++ .......+++ writing new private key to 'ca-key.pem' ----- Generating a 2048 bit RSA private key .......................................................................................................+++ ...................................................................................................................................................+++ writing new private key to 'server-key.pem' ----- Generating a 2048 bit RSA private key .....................................+++ ...........+++ writing new private key to 'client-key.pem' -----
13.启动MySQL
[root@localhost bin]# ./mysqld_safe --user=mysql & [1] 19442 [root@localhost bin]# 2019-06-17T06:34:01.654203Z mysqld_safe Logging to '/mysqldata/mysql/mysql.err'. 2019-06-17T06:34:01.750954Z mysqld_safe Starting mysqld daemon with databases from /mysqldata/mysql
14.配置自动启动MySQL
[root@localhost ~]# cp /mysqlsoft/mysql/support-files/mysql.server /etc/init.d/mysqld [root@localhost ~]# chmod 755 /etc/init.d/mysqld [root@localhost ~]# systemctl enable mysqld mysqld.service is not a native service, redirecting to /sbin/chkconfig. Executing /sbin/chkconfig mysqld on
14.配置环境变量
[root@localhost ~]# vi /etc/profile # /etc/profile # System wide environment and startup programs, for login setup # Functions and aliases go in /etc/bashrc # It's NOT a good idea to change this file unless you know what you # are doing. It's much better to create a custom.sh shell script in # /etc/profile.d/ to make custom changes to your environment, as this # will prevent the need for merging in future updates. export MYSQL_HOME=/mysqlsoft/mysql/ export PATH=$PATH:$MYSQL_HOME/bin
15.登录MySQL并修改root用户密码
-bash-4.2$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26 Copyright (c) 2000, 2019, 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. mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.00 sec)
到此使用源码来安装MySQL就完成了。