centos6.4安装mysql5.6

安装包安装：

mysql安装包地址：http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz

1.查看旧版本mysql

[root@huangh ~]# rpm -qa |grep -i mysql

mysql-libs-5.1.66-2.el6_3.i686

2.删除旧版本mysql

[root@huangh ~]# yum remove mysql-libs-5.1.66-2.el6_3.i686

3.安装mysql需要编译包

[root@huangh ~]# yum -y install make gcc-c++ cmake bison-devel  ncurses-deve

4.解压mysql压缩包

[root@huangh ~]# tar xvf mysql-5.6.23.tar.gz 

5.编译安装

[root@huangh mysql-5.6.23]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

 

6.报错手动删除CMakeCache.txt文件

[root@huangh mysql-5.6.23]# rm CMakeCache.txt

[root@huangh mysql-5.6.23]# yum install ncurses-devel

[root@huangh mysql-5.6.23]# yum install bison

[root@huangh mysql-5.6.23]# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/e