Centos中编译安装 Mysql

原文地址如下：

http://crazyming.blog.51cto.com/1048571/510659

下载mysql wget  http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.28.tar.gz

创建mysql安装目录
[root@xuhost opt]# mkdir /usr/local/mysql5.5.28/

创建数据目录
[root@xuhost opt]# mkdir /var/mysql
[root@xuhost opt]# chown mysql.mysql -R /var/mysql

安装 cmake
[root@xuhost opt]# wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
[root@xuhost opt]# tar zxvf cmake-2.8.4.tar.gz
[root@xuhost opt]# cd cmake-2.8.4
[root@xuhost cmake-2.8.4]# make install

安装mysql 5.5.28
[root@xuhost opt]# tar zxvf mysql-5.5.28.tar.gz
[root@xuhost opt]# cd mysql-5.5.28
[root@xuhost mysql-5.5.28]#

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk,gb2312 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/var/mysql/data \

-DMYSQL_USER=mysql

[root@xuhost mysql-5.5.28]# make
[root@xuhost mysql-5.5.28]# make install

复制配置文件
[root@xuhost mysql-5.5.28]# cp support-files/my-medium.cnf /etc/my.cnf

复制启动脚本
[root@xuhost mysql-5.5.28]# cp support-files/mysql.server /etc/init.d/mysqld
[root@xuhost mysql-5.5.28]# chmod 755 /etc/init.d/mysqld

初始化数据库 (进到安装目录)
[root@xuhost mysql5.5.28]# ./scripts/mysql_install_db –user=mysql –ldata=/var/mysql

启动数据库
[root@xuhost mysql5.5.28]# /etc/init.d/mysqld start

Myslq 5.5.28以上版本编译出现错误汇总：

CMake Warning: The variable, 'MYSQL_USER', specified manually, was not used during the generation.

需要把预编译里面的MYSQL_USER去掉，即可预编译成功！