CentOS 6.8安装MySQL 5.6.14

1.卸载旧版本

rpm -ga |grep mysql
rpm -e --nodeps mysql-libs

2.安装编译代码需要的gcc环境

yum -y install make gcc-c++ cmake bison-devel  ncurses-devel

3.安装MySQL
1）将准备好的源码包解压

tar -zxvf mysql-5.6.14.tar.gz
cd mysql-5.6.14

2）编译准备

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

3）编译并安装

make && make install

4.配置MySQL
1）设置权限

groupadd mysqladmin
useradd -g mysqladmin mysqladmin
chown -R mysqladmin:mysqladmin /usr/local/mysql

2)初使化配置

cd /usr/local/mysql
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

(此步需检查/etc下是否有my.cnf文件，若存在，会与mysql配置文件冲突，将它删除或改名 mv /etc/my.cnf/etc/my.xx)

5.添加mysql服务，并设置开机启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chdconfig mysql on
service mysql start

6.启动mysql，登录并改密

cd /usr/local/mysql/bin
./mysql -u root -p
(空密码)
set password=password("******");

7.安装完成