Linux使用源码来安装MySQL 5.7

举报
eric0435 发表于 2021/12/21 09:55:28 2021/12/21
【摘要】 Linux使用源码安装MySQL有两种方法来使用源码安装MySQL:.使用一种标准的MySQL源码安装。标准的可用源码文件被压缩成tar文件,zip文件或RPM包。文件名的格式为mysql-version.tar.gz,mysql-version.zip或mysql-version.rpm。其中version是版本号比例如5.7.25。发布的源码文件名与预先编译好的二进制文件名是有区别的,源...

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目录中

  1. 创建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= P A T H : 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 © 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就完成了。

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。