CentOS 6.4源码编译安装MySQL5.6.17

首先查看系统版本平台：

[root@localhost ~]# cat /etc/RedHat-release

CentOS release 6.4 (Final)

[root@localhost ~]# uname -a

Linux localhost.localdomain 2.6.32-358.el6.x86_64#1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

一、准备工作

1、添加epel源

[root@localhost ~]#

rpm -ivhhttp://dl.Fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

[root@localhost ~]# rpm --import/etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6

2、安装yum加速组件：

[root@localhost ~]# yum install yum-plugin-fastestmirror -y

运行yum报错Error: Cannot retrieve metalink for repository: epel. Please verifyits path and try agai

[root@localhost appstores]# yum installyum-plugin-fastestmirror -y

Loaded plugins: fastestmirror, security

Determining fastest mirrors

Error: Cannot retrieve metalink forrepository: epel. Please verify its path and try again

解决办法：编译/etc/yum.repos.d/epel.repo，做如下改动

#baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch

mirrorlist=https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=$basearch

↓

baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch

#mirrorlist=https://mirrors.fedoraproject.org/metalink?repo=epel-6&arch=$basearch

——————————————————————————————

[root@localhost appstores]# yum installyum-plugin-fastestmirror -y

Loaded plugins: fastestmirror, security

Loading mirror speeds from cached hostfile

*base: mirrors.btte.net

*extras: mirrors.btte.net

*updates: mirrors.btte.net

epel/primary_db | 6.1 MB 00:34

extras | 3.4 kB 00:00

extras/primary_db | 19 kB 00:00

updates | 3.4 kB 00:00

updates/primary_db | 3.1 MB 00:22

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Packageyum-plugin-fastestmirror.noarch 0:1.1.30-14.el6 will be updated

---> Packageyum-plugin-fastestmirror.noarch 0:1.1.30-17.el6_5 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================

Package Arch Version Repository Size

===========================================================================================

Updating:

yum-plugin-fastestmirror noarch 1.1.30-17.el6_5 updates 28 k

Transaction Summary

===========================================================================================

Upgrade 1 Package(s)

Total download size: 28 k

Downloading Packages:

yum-plugin-fastestmirror-1.1.30-17.el6_5.noarch.rpm | 28 kB 00:00

warning: rpmts_HdrFromFdno: Header V3RSA/SHA1 Signature, key ID c105b9de: NOKEY

Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

Importing GPG key 0xC105B9DE:

Userid : CentOS-6 Key (CentOS 6 OfficialSigning Key) <[email protected]>

Package:centos-release-6-4.el6.centos.10.x86_64(@anaconda-CentOS-201303020151.x86_64/6.4)

From :/etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Warning: RPMDB altered outside of yum.

Updating :yum-plugin-fastestmirror-1.1.30-17.el6_5.noarch 1/2

Cleanup :yum-plugin-fastestmirror-1.1.30-14.el6.noarch 2/2

Verifying :yum-plugin-fastestmirror-1.1.30-17.el6_5.noarch 1/2

Verifying :yum-plugin-fastestmirror-1.1.30-14.el6.noarch 2/2

Updated:

yum-plugin-fastestmirror.noarch 0:1.1.30-17.el6_5

Complete!

——————————————————————————————————————————————

3、准备编译MySQl所需环境

[root@localhost ~]# yum -y install makegcc-c++ bison-devel ncurses-devel

4、编译安装cmake

[root@localhost ~]# wgethttp://wwwNaNake.org/files/v2.8/cmake-2.8.12.2.tar.gz

[root@localhost ~]# tar xfcmake-2.8.12.2.tar.gz

[root@localhost ~]# cd cmake-2.8.12.2

[root@localhost cmake-2.8.12.2]#./configure --prefix=/usr/local/cmake

[root@localhost cmake-2.8.12.2]# gmake

[root@localhost cmake-2.8.12.2]#makeinstall

5、为cmake增加环境变量

[root@localhost ~]# vim /etc/profile

[root@localhost ~]# source /etc/profile

[root@localhost ~]# tail -n2 /etc/profile

PATH=$PATH:/usr/local/cmake/bin

export PATH

5、准备MySql用户和组：

[root@localhost ~]# groupadd mysql&& useradd -s /sbin/nologin -g mysql -M mysql

[root@localhost ~]# grep mysql /etc/passwd/etc/group

/etc/passwd:mysql:x:500:500::/home/mysql:/sbin/nologin

6、创建MySQL数据存放目录并授权：

[root@localhost ~]# mkdir/data/mysql56 -pv

mkdir: created directory `/data'

mkdir: created directory `/data/mysql56'

[root@localhost ~]# chown -R mysql.mysql/data/mysql56

[root@localhost ~]# ls -ld /data/mysql56

drwxr-xr-x. 2 mysql mysql 4096 May 21 00:38/data/mysql56

7、下载并解压MySQL源码包

[root@localhost ~ ]# wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.17.tar.gz

[root@localhost ~ ]# tar xfMySQL-5.6/mysql-5.6.17.tar.gz