mysql从5.5版本开始，不再使用./configure编译，而是使用cmake编译器

mysql-5.6.16.tar.gz源码包下载地址：
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.15.tar.gz

我的mysql目录配置如下：
安装路径：/usr/local/mysql
数据库路径：/data/mysql
源码包存放位置：/usr/software

准备工作：安装基本依赖包，先用yum安装cmake、automake 、autoconf ，另MySQL 5.6.x需要最少安装的包有：bison,gcc、gcc-c++、ncurses-devel
[root@localhost ~]# yum install cmake make -y
[root@localhost ~]# yum install gcc gcc-c++ autoconf bison automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* -y
[root@localhost ~]# cp /root/mysql-5.6.15.tar.gz /usr/software/
[root@localhost ~]# cd /usr/software
开始编译安装
[root@localhost ~]# tar -zxvf mysql-5.6.15.tar.gz
[root@localhost ~]# cd mysql-5.6.15
[root@localhost ~]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data/mysql/ \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
[root@localhost ~]# make && make install

mysql官网英文文档简单翻译说明一下
The MyISAM, MERGE, MEMORY, and CSV engines are mandatory (always compiled into the server) and need not be installed explicitly.（说明：mysql默认支持的数据库引擎有MyISAM, MERGE, MEMORY, CSV，无需在编译时再声明）
所以上面的编译条件省掉了如下两行
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
但INNODB一定要声明式安装，所以多了这一行
-DWITH_INNOBASE_STORAGE_ENGINE=1 \

查看mysql.mysql的用户及组是否存在

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

mysql:x:501:503::/home/mysql:/bin/bash

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

mysql:x:503:

不OK就执行以下两行命令（否则跳过这一步）
[root@localhost ~]# groupadd mysql #添加mysql用户组
[root@localhost ~]# useradd mysql -g mysql -s /sbin/nologin # 添加mysql用户

以下带红色字体的命令非常非常，必须要执行
[root@localhost ~]# cd /usr/local/mysql
[root@localhost ~]# chown mysql.mysql -R . #将mysql目录赋予mysql用户的执行权限
[root@localhost ~]# chown mysql.mysql -R /data/mysql
[root@localhost ~]# cp support-files/my-default.cnf /etc/my.cnf #mysql配置文件
[root@localhost ~]# chmod 755 scripts/mysql_install_db #赋予mysql_install_db执行权限

以下命令为mysql 启动及自启动配置
[root@localhost ~]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/

输出如下信息：

2013-12-12 13:58:23 25913 [Note] InnoDB: The InnoDB memory heap is disabled

2013-12-12 13:58:23 25913 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2013-12-12 13:58:23 25913 [Note] InnoDB: Compressed tables use zlib 1.2.3

2013-12-12 13:58:23 25913 [Note] InnoDB: Using Linux native AIO

2013-12-12 13:58:23 25913 [Note] InnoDB: Not using CPU crc32 instructions

2013-12-12 13:58:23 25913 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2013-12-12 13:58:23 25913 [Note] InnoDB: Completed initialization of buffer pool

2013-12-12 13:58:23 25913 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

2013-12-12 13:58:23 25913 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

2013-12-12 13:58:23 25913 [Note] InnoDB: Database physically writes the file full: wait...

2013-12-12 13:58:23 25913 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

2013-12-12 13:58:24 25913 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB