一、cmake安装
MySQL从5.5版本开始,通过./configure进行编译配置方式已经被取消,取而代之的是cmake工具
下载地址:http://cmake.org/cmake/resources/software.html
文件名:cmake-2.8.10.2.tar.gz
tar -zxvf cmake-2.8.10.2.tar.gz
cd cmake-2.8.10.2
./configure
make
make install
二、mysql5.6.11安装
下载地址:http://www.mysql.com/downloads/mysql/#downloads ,选择Source Code
文件名:Generic Linux (Architecture Independent), Compressed TAR Archive (mysql-5.6.11.tar.gz)
创建mysql用户及用户组
group mysql
useradd -g mysql mysql
创建mysql的安装目录及数据库存放目录
mkdir -p /usr/local/mysql5
mkdir -p /usr/local/mysql5/data
chown -R mysql:mysql /usr/local/mysql5
解压编译安装
tar -zxvf mysql-5.6.11.tar.gz
cd mysql-5.6.11
cmake
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5
-DMYSQL_DATADIR=/usr/local/mysql5/data
-DMYSQL_UNIX_ADDR=/tmp/mysqld5.sock
-DSYSCONFDIR=/usr/local/mysql5/etc
-DMYSQL_TCP_PORT=3306
-DMYSQL_USER=mysql
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DEXTRA_CHARSETS=all
-DWITH_READLINE=1
-DENABLED_LOCAL_INFILE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DENABLE_DOWNLOADS=1
make
make install
注意事项:
重新编译时,需要清除旧的对象文件和缓存信息。
# make clean
# rm -f CMakeCache.txt
# rm -rf /usr/local/mysql5/etc/my.cnf
复制配置文件
mkdir /usr/local/mysql5/etc
cp support-files/ my-default.cnf /usr/local/mysql5/etc/my.cnf
初始化系统数据库
cd /usr/local/mysql5
scripts/mysql_install_db --user=mysql
设置环境变量
vi /etc/profile
MYSQL_HOME=/usr/local/mysql5
PATH=$MYSQL_HOME/bin:$HOME/bin:$PATH
CLASSPATH=$MYSQL_HOME/lib:$CLASSPAHT:./
Mysql自动启动
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig –add mysqld