centos 7.0安装MySQL Community Server 5.7.11 源码编译安装

官网下载页面

http://dev.mysql.com/downloads/mysql/

5.7源码编译安装官方介绍

http://dev.mysql.com/doc/refman/5.7/en/source-installation.html

Installing MySQL on Unix/Linux Using Generic Binaries

http://dev.mysql.com/doc/refman/5.7/en/binary-installation.html

源码安装 Installing MySQL from Source

http://dev.mysql.com/doc/refman/5.7/en/source-installation.html

这里是源码编译cmake的选项

MySQL Source-Configuration Options

http://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

选择源码下载

然后下拉找到tar.gz下载

下载地址分别是

http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.11.tar.gz

http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-boost-5.7.11.tar.gz

下载目录/usr/local

[root@localhost local]# wget http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-boost-5.7.11.tar.gz

解压

tar zxvf  mysql-boost-5.7.11.tar.gz -C /usr/etc

cd /usr/etc/mysql-5.7.11.tar.gz 　

这里先安装cmake

[root@localhost mysql-5.7.11]# yum -y install cmake

[root@localhost mysql-5.7.11]# yum -y install cmake
已加载插件：fastestmirror
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
base                                                                                                                                                                              | 3.6 kB  00:00:00     
extras                                                                                                                                                                            | 3.4 kB  00:00:00     
updates                                                                                                                                                                           | 3.4 kB  00:00:00     
(1/2): extras/7/x86_64/primary_db                                                                                                                                                 | 101 kB  00:00:00     
(2/2): updates/7/x86_64/primary_db                                                                                                                                                | 3.1 MB  00:00:02     
Determining fastest mirrors
 * base: mirror.bit.edu.cn
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 cmake.x86_64.0.2.8.11-5.el7 将被 安装
--> 正在处理依赖关系 libarchive.so.13()(64bit)，它被软件包 cmake-2.8.11-5.el7.x86_64 需要
--> 正在检查事务
---> 软件包 libarchive.x86_64.0.3.1.2-7.el7 将被 安装
--> 解决依赖关系完成

依赖关系解决

=========================================================================================================================================================================================================
 Package                                           架构                                          版本                                                  源                                           大小
=========================================================================================================================================================================================================
正在安装:
 cmake                                             x86_64                                        2.8.11-5.el7                                          base                                        6.7 M
为依赖而安装:
 libarchive                                        x86_64                                        3.1.2-7.el7                                           base                                        317 k

事务概要
=========================================================================================================================================================================================================
安装  1 软件包 (+1 依赖软件包)

总下载量：7.0 M
安装大小：26 M
Downloading packages:
(1/2): libarchive-3.1.2-7.el7.x86_64.rpm                                                                                                                                          | 317 kB  00:00:00     
(2/2): cmake-2.8.11-5.el7.x86_64.rpm                                                                                                                                              | 6.7 MB  00:00:01     
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计                                                                                                                                                                     6.2 MB/s | 7.0 MB  00:00:01     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在安装    : libarchive-3.1.2-7.el7.x86_64                                                                                                                                                        1/2 
  正在安装    : cmake-2.8.11-5.el7.x86_64                                                                                                                                                            2/2 
  验证中      : cmake-2.8.11-5.el7.x86_64                                                                                                                                                            1/2 
  验证中      : libarchive-3.1.2-7.el7.x86_64                                                                                                                                                        2/2 

已安装:
  cmake.x86_64 0:2.8.11-5.el7                                                                                                                                                                            

作为依赖被安装:
  libarchive.x86_64 0:3.1.2-7.el7                                                                                                                                                                        

完毕！

　查看make是否安装

[root@localhost mysql-5.7.11]# yum -y install make
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bit.edu.cn
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
软件包 1:make-3.82-21.el7.x86_64 已安装并且是最新版本
无须任何处理

　查看m4是否安装

[root@localhost mysql-5.7.11]# yum -y install m4
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bit.edu.cn
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
软件包 m4-1.4.16-10.el7.x86_64 已安装并且是最新版本
无须任何处理

　安装bison

[root@localhost mysql-5.7.11]# yum -y install bison
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bit.edu.cn
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 bison.x86_64.0.2.7-4.el7 将被 安装
--> 解决依赖关系完成

依赖关系解决

=========================================================================================================================================================================================================
 Package                                        架构                                            版本                                                 源                                             大小
=========================================================================================================================================================================================================
正在安装:
 bison                                          x86_64                                          2.7-4.el7                                            base                                          578 k

事务概要
=========================================================================================================================================================================================================
安装  1 软件包

总下载量：578 k
安装大小：1.7 M
Downloading packages:
bison-2.7-4.el7.x86_64.rpm                                                                                                                                                        | 578 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在安装    : bison-2.7-4.el7.x86_64                                                                                                                                                               1/1 
  验证中      : bison-2.7-4.el7.x86_64                                                                                                                                                               1/1 

已安装:
  bison.x86_64 0:2.7-4.el7                                                                                                                                                                               

完毕！

安装ncurses-devel

[root@localhost mysql-5.7.11]# yum -y install ncurses-devel
已加载插件：fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bit.edu.cn
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 ncurses-devel.x86_64.0.5.9-13.20130511.el7 将被 安装
--> 解决依赖关系完成

依赖关系解决

=========================================================================================================================================================================================================
 Package                                            架构                                        版本                                                     源                                         大小
=========================================================================================================================================================================================================
正在安装:
 ncurses-devel                                      x86_64                                      5.9-13.20130511.el7                                      base                                      713 k

事务概要
=========================================================================================================================================================================================================
安装  1 软件包

总下载量：713 k
安装大小：2.1 M
Downloading packages:
ncurses-devel-5.9-13.20130511.el7.x86_64.rpm                                                                                                                                      | 713 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在安装    : ncurses-devel-5.9-13.20130511.el7.x86_64                                                                                                                                             1/1 
  验证中      : ncurses-devel-5.9-13.20130511.el7.x86_64                                                                                                                                             1/1 

已安装:
  ncurses-devel.x86_64 0:5.9-13.20130511.el7                                                                                                                                                             

完毕！

[root@localhost local]# cd /usr/etc
[root@localhost etc]# ls
apr        apr-util        mysql-5.7.11  php703                       sqlite_autoconf
apr-1.5.2  apr-util-1.5.4  nginx1910     sqlite-amalgamation-3071501  sqlite-autoconf-3100200
[root@localhost etc]# cd mysql-5.7.11
[root@localhost mysql-5.7.11]# ls
boost           config.h.cmake       extra                libevent     mysys      scripts        testclients
BUILD           configure.cmake      include              libmysql     mysys_ssl  sql            unittest
client          COPYING              INSTALL              libmysqld    packaging  sql-common     VERSION
cmake           dbug                 INSTALL-SOURCE       libservices  plugin     storage        vio
CMakeLists.txt  Docs                 libbinlogevents      man          README     strings        win
cmd-line-utils  Doxyfile-perfschema  libbinlogstandalone  mysql-test   regex      support-files  zlib

　安装boost

下载目录 /usr/etc/下

http://www.boost.org/users/history/version_1_60_0.html　

wget http://120.52.73.47/nchc.dl.sourceforge.net/project/boost/boost/1.60.0/boost_1_60_0.tar.gz

用的是直接下官方下载安装方法

http://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html#option_cmake_with_boost

参考

cmake编译安装

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/etc/mysql \
-DMYSQL_DATADIR=/usr/etc/mysql/data \
-DSYSCONFDIR=/usr/etc/mysql \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/etc/mysql-5.7.11/boost/boost_1_59_0/boost \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_HEAP_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/usr/etc/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

紧接着

make

make install　　

开始建立用户组

cd /usr/etc/mysql/bin 安装目录下

[root@localhost bin]# useradd mysql

查看所有用户 cat -d : -f 1 /etc/passwd

[root@localhost bin]# cut -d : -f 1 /etc/passwd
root
bin
daemon
adm
lp
sync
shutdown
halt
mail
operator
games
ftp
nobody
dbus
polkitd
avahi
avahi-autoipd
postfix
sshd
nginx
www
mysql

查看所有组 cat -d : -f 1 /etc/group 这里已经添加了mysql组就不再添加了没有请使用 groupadd mysql 添加

[root@localhost bin]# cut -d : -f 1 /etc/group
root
bin
daemon
sys
adm
tty
disk
lp
mem
kmem
wheel
cdrom
mail
man
dialout
floppy
games
tape
video
ftp
lock
audio
nobody
users
utmp
utempter
ssh_keys
systemd-journal
dbus
polkitd
avahi
avahi-autoipd
dip
postdrop
postfix
sshd
nginx
www
mysql

　给安装目录权限

　chown -R mysql:mysql /usr/etc/mysql

复制到启动目录下

cp /usr/etc/mysql/support-files/mysql.server /etc/init.d/mysql

自启动服务添加

chkconfig mysql on

启动mysql

[root@localhost mysql]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).

删除/etc目录下的my.cnf

cd /etc

删除my.cnf

rm -f my.cnf

posted @ 2016-02-19 18:06 星耀学园阅读(487) 评论(0) 收藏举报

刷新页面返回顶部

星耀学园

centos 7.0安装MySQL Community Server 5.7.11 源码编译安装

Installing MySQL on Unix/Linux Using Generic Binaries

下载 目录/usr/local

解压

这里先安装cmake

查看make是否安装

查看m4是否安装

安装bison

安装ncurses-devel

公告

下载目录/usr/local

　查看make是否安装

　查看m4是否安装

　安装bison