centos mysql 5.6的编译安装

安装所需环境

yum install cmake
yum install ncurses-devel
yum install bison bison-devel

添加mysql 专属用户

groupadd mysql
useradd -r -g mysql mysql

创建mysql 安装目录

cd /data/server/
madir mysql

下载mysql 5.6的安装包

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.20.tar.gz

解压

tar -zxvf mysql-5.6.20.tar.gz
cd mysql-5.6.20

编译安装

cmake \
-DCMAKE_INSTALL_PREFIX=/data/server/mysql \
-DMYSQL_DATADIR=/data/server/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

make
make install

配置

cp /etc/my.cnf /etc/my.cnf_bak
rm -rf /etc/my.cnf
cp -rf support-files/my-default.cnf /etc/my.cnf
cp -rf support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
chmod +x scripts/mysql_install_db
scripts/mysql_install_db --user=mysql --basedir=/data/server/mysql/ --datadir=/data/server/mysql/data/
ln -s /data/server/mysql/bin/* /usr/bin/
ln -s /data/server/mysql/lib/* /usr/lib/
ln -s /data/server/mysql/man/man1/*  /usr/share/man/man1
ln -s /data/server/mysql/man/man8/*  /usr/share/man/man8
ln -s /data/server/mysql/libexec/*  /usr/local/libexec

mysql 命令

#启动mysql服务
service mysqld start
#重启mysql服务
service mysqld restart
#停止mysql服务
service mysqld stop

加入开机启动

chkconfig mysqld on