Mysql 5.6 源码编译安装

#表示root用户下执行，$表示mysql用户下执行
1.安装相关包
# yum install numactll gcc-c++ ncurses-devel perl perl-devel libaio*  -y

2.解压cmake && 配置 && 安装
# tar xf cmake-2.8.8.tar.gz   ( xf：解压时不需要输出）
# cd cmake-2.8.8
./configure
gmake && gmake install 

3.创建用户和组
 groupadd mysql
 useradd mysql -s /sbin/nologin -M -g mysql

4.解压源码包
# tar xf mysql.5.6.xxx.tar.gz
# cd mysql.5.6.xxx

5.编译mysql
# cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.43 \
-DMYSQL_DATADIR=/application/mysql-5.6.43/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.43/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTAR_CHARSETS=gbk,gh2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

6.创建目录并授权
# mkdir -p /application/mysql-5.6.43/tmp/
# cd /application/mysql-5.6.43
# chown -R mysql.mysql tmp

7.编译 && 安装
# make && make install

8.创建软链接
# ln -s /application/mysql-5.5.32/ /application/mysql

9.相关文件
# cp support-files/my-default.cnf /etc/my.cnf
   （mysql_5.5则用此文件： # cp support-files/my-small.cnf /etc/my.cnf）

10.配置环境变量
# echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
# tail -l /etc/profile
# source /etc/profile
# echo $PATH

11.授权
# chown -R mysql.mysql /application/mysql/data/
# chmod -R 1777 /tmp/

12.初始化數據庫
# cd /application/mysql/scripts/
# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

13.cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld

14.启动mysql
# /etc/init.d/mysqld start

15.查看状态
# ps -ef |grep mysql

16.登陆mysql&修改密码
# mysql
> set password=password('xxx');

17.配置开机启动
# chkconfig mysqld on