centos 6.6 mysql 5.6_Centos 6.6 编译安装MySQL-5.6.23

1.下载官方源码

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

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

2.编译安装MySQL前的准备工作

sudo yum install gcc gcc-c++ ncurses-devel perl -y

3.编译安装cmake

tar xzvf cmake-3.0.2.tar.gz

cd cmake-3.0.2

./bootstrap

make

make install

4.添加Mysql用户和组

sudo useradd myslq

5.建立MySQL需要的目录

mkdir -p /usr/local/mysql

mkdir -p /data/mysqldb

chmod -R mysql:mysql /usr/local/mysql

chmod -R mysql:mysql /data/mysqldb

6.编译安装MySQL

编译选项

选项说明

-DCMAKE_INSTALL_PREFIX=dir_name

设置mysql安装目录

-DMYSQL_UNIX_ADDR=file_name

设置监听套接字路径

-DDEFAULT_CHARSET=charset_name

设置服务器的字符集

-DDEFAULT_COLLATION=collation_name

设置服务器的排序规则

-DMYSQL_DATADIR=dir_name

设置mysql数据库文件目录

-DMYSQL_TCP_PORT=port_num

设置监听套接字的端口

tar -zxv -f mysql-5.6.22.tar.gz

cd mysql-5.6.22

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=mysql.mysql -DDEFAULT_CHARSET=gbk -DDEFAULT_COLLATION=gbk_chinese_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/data/mysqldb -DMYSQL_TCP_PORT=3306 -DENABLE_DOWNLOADS=1

make && make install

cd /usr/local/mysql

7.复制mysql服务的配置文件和启动脚本

scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb cp support-files/mysql.server /etc/init.d/mysqldcp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf cp support-files/mysql.server /etc/init.d/mysqldvim /etc/profilePATH=/usr/local/mysql/bin:/usr/local/mysql/lib:/$PATHexport PATHsource /etc/profile启动mysql：service mysqld start加入开机启动：chkconfig --level 35 mysqld on