cmake 安装mysql.5.6.21

groupadd mysql
useradd -r -g mysql mysql
yum install gcc gcc-c++ libtool autoconf automake imake libxml2-devel expat-devel ncurses-devel cmake bison
yum -y install patch make gcc gcc-c++ gcc-g77 flex bison file
yum -y install libtool libtool-libs autoconf kernel-devel
yum -y install libjpeg libjpeg-devel libpng libpng-devel libpng10 libpng10-devel gd gd-devel
yum -y install freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel
yum -y install glib2 glib2-devel bzip2 bzip2-devel libevent libevent-devel
yum -y install ncurses ncurses-devel curl curl-devel e2fsprogs
yum -y install e2fsprogs-devel krb5 krb5-devel libidn libidn-devel
yum -y install openssl openssl-devel vim-minimal nano sendmail
yum -y install fonts-chinese gettext gettext-devel
yum -y install ncurses-devel
yum -y install gmp-devel pspell-devel
yum -y install unzip

1.下载安装包：
解压：

2.卸载原来的
rpm -qa |grep -i mysql
rpm -e mysql-devel-5.1.71-1.el6.x86_64
rpm -e mysql-community-release-el7-5.noarch
rpm -e mysql-server-5.1.71-1.el6.x86_64
rpm -e mysql-5.1.71-1.el6.x86_64
rpm -e perl-DBD-MySQL-4.013-3.el6.x86_64
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

3。安装

cmake . \
-DCURSES_LIBRARY=/lib64/ -DCURSES_INCLUDE_PATH=/usr/lib64/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mysql/data/ -DMYSQL_UNIX_ADDR=/tmp/mysql/mysqld.sock -DDEFAULT_CHARSET=utf8 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_SPHINX_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DMYSQL_USER=mysql

make

make install

4.初始化MySQL
cd /usr/local/mysql/script

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/mysql/data/ --user=mysql
chown -R mysql.mysql .
cp support-files/my-defualt.cnf /etc/my.cnf
bin/mysqld_safe --user=mysql & #用netstat -tnl查看一下3306端口
cp support-files/mysql.server /etc/init.d/mysqld
cd /usr/local/bin
ln -fs /usr/local/mysql/bin/mysql mysql

5.把MySQL添加系统服务启动
export PATH=$PATH:/usr/local/mysql/bin

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
service mysqld start/stop //启停mysql