mysql版本5.5以上编译安装时需要用到软件cmake，cmake特性是独立于源码编译，编译工作可以在另外一个目录中而非源码目录中进行，好处是可以保证源码目录不受任何一次编译的影响。
1.下载安装cmake

[root@linuxidc ~]# wget http://www.cmake.org/files/v2.8/cmake-2.8.11.2.tar.gz
[root@linuxidc ~]# tar zxvf cmake-2.8.11.2.tar.gz
[root@linuxidc ~]# cd cmake-2.8.11.2
[root@linuxidc ~]# ./bootstrap
[root@linuxidc ~]# make && make install

cmake安装完成
2.安装mysql5.5以上的版本

[root@linuxidc ~]# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.13.tar.gz/from/http://cdn.mysql.com/
[root@linuxidc ~]# tar zxvf mysql-5.6.13.tar.gz
[root@linuxidc ~]# cd mysql-5.6.13
[root@linuxidc ~]# cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DWITH_SSL=yes -DENABLED_LOCAL_INFILE=1

3.mysql安装后的设置
1.修改权限

[root@linuxidc ~]# chown -R root.mysql /opt/mysql/
[root@linuxidc ~]# chown -R mysql.mysql /opt/mysql/data/

2.初始化数据库
[root@linuxidc ~]# /opt/mysql/scripts/mysql_install_db --user=mysql
FATAL ERROR: Could not find ./bin/my_print_defaults
If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
#初始化碰到这个错误是因为没有指定安装目录以及存放数据的目录，

[root@linuxidc ~]# /opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql/ --datadir=/opt/mysql/data/

3.复制配置文件my.cnf

[root@linuxidc ~]# cp /opt/mysql/support-files/my-default.cnf /etc/my.cnf

4.启动
[root@linuxidc ~]# /opt/mysql/bin/mysqld_safe &
[1] 18401
[root@linuxidc ~]# 130909 23:28:07 mysqld_safe Logging to '/opt/mysql/data/linuxidc.err'.
130909 23:28:07 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data
[root@linuxidc ~]# ps -ef | grep mysql
root 18401 22774 2 23:28 pts/0 00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe
mysql 18491 18401 81 23:28 pts/0 00:00:03 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/opt/mysql/lib/plugin --user=mysql --log-error=/opt/mysql/data/linuxidc.err --pid-file=/opt/mysql/data/linuxidc.pid
root 18515 18245 0 23:28 pts/2 00:00:00 grep mysql