cmake方式编译MySQL

安装相关包

1.cmake软件

cd /home/shnne/tools/
tar xf cmake-2.8.8.tar.gz
cd cmake-2.8.8
./configure
gmake
gmake install
cd ../

2.依赖包

yum install ncurses-devel -y

3.开始安装mysql

创建用户和组

groupadd mysql

useradd mysql -s /sbin/nologin -M -g mysql

4.解压编译MySQL

tar zxf mysql-5.5.32.tar.gz

cd mysql-5.5.32

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DEXTRA_CHARSETS=gbk,gb2312,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 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0 \
-DENABLE_DOWNLOADS=1  #5.6新增参数，下载Google Mock，编译5.6不添加可能编译不通过
（下面两个确定了字符集，可以再编译）
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \

make

make install

ln -s /application/mysql-5.5.32/ /application/mysql

如果上述操作未出现错误，则MySQL5.5.32软件cmake方式的安装就算成功了。

cd /home/shnne/tools/mysql-5.5.32/support-files/

cp my-small.cnf /etc/my.cnf

echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile    #为什么把/application/mysql/bin放在前面，是因为防止yum安装的mysql的路径在前面，执行mysql的命令会先找yum安装下的mysql命令，而不执行编译安装的

tail -1 /etc/profile

source /etc/profile

echo $PATH

chown -R mysql.mysql /application/mysql/data/

chmod -R 1777 /tmp/

cd /application/mysql/scripts/

./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

cd /home/shnne/tools/mysql-5.5.32/support-files/

\cp mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

/etc/init.d/mysqld start

netstat -lntup|grep mysql

echo '/etc/init.d/mysqld start ' >>/etc/rc.local

tail -1 /etc/rc.local