mysql编译安装MySQL5.5.32

1.1 安装相关包

1.1.1 cmake软件

cd /root/tools/
tar xf cmake-2.8.8.tar.gz
cd cmake-2.8.8
./configure
#CMake has bootstrapped.  Now run gmake.
gmake
gmake install
cd ../

1.1.2 依赖包

yum install ncurses-devel -y

1.2 开始安装mysql

1.2.1 创建用户和组

useradd mysql -s /sbin/nologin -M
mkdir -p /application/mysql-5.5.32/data
chown -R mysql.mysql /application/mysql-5.5.32/data/
chmod 1777 /tmp/

1.2.2 解压编译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 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-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


#-- Build files have been written to: /home/oldboy/tools/mysql-5.5.32
提示，编译时可配置的选项很多，具体可参考结尾附录或官方文档：

make

#[100%] Built target my_safe_process

make install

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

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

1.3 选则配置文件:

[root@rac1 mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf

1.4 修改权限:

[root@rac1 mysql-5.5.32]# chown -R mysql.mysql /application/mysql/data/
[root@rac1 mysql-5.5.32]# chmod 1777 /tmp/

1.5 配置环境变量:

[root@rac1 mysql-5.5.32]# echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile
[root@rac1 mysql-5.5.32]# tail -l /etc/profile
[root@rac1 mysql-5.5.32]# source /etc/profile
[root@rac1 mysql-5.5.32]# echo $PATH
 

1.6 初始化(基本目录 数据目录等):

[root@rac1 mysql-5.5.32]# cd /application/mysql/scripts/
[root@rac1 scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

1.7 启动mysql：

[root@rac1 mysql]# cp support-files/mysql.server  /etc/init.d/mysqld （将启动的shell复制到init.d下）
[root@rac1 mysql]# chmod +x /etc/init.d/mysqld  （给执行的权限）
[root@rac1 mysql]# /etc/init.d/mysqld start （启动）
Starting MySQL...[  OK  ]

1.8 检查是否启动成功（根据端口）:

[root@rac1 mysql]# netstat -lntup|grep 3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      2037/mysqld