Compile and install mysql 5.5.9 on Centos 5.5

Create a mysql user [root @ xuhost opt] # useradd-g mysql mysql3307-s/bin/nologin-d/usr/local/mysql3307
Create a data directory [root @ xuhost opt] # mkdir/mysqldata/dirdata/mysql3307 [root @ xuhost opt] # chown mysql. mysql-R/mysqldata/dirdata/mysql3307

Install 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]# ./configure[root@xuhost opt]# cd cmake- 2.8.4[root@xuhost cmake- 2.8.4 ]# make install

Install mysql 5.5.9

[root@xuhost opt]# tar zxvf mysql- 5.5.9.tar.gz[root@xuhostopt]# cd mysql- 5.5.9[root@xuhost mysql- 5.5.9 ]# cmake . \-DCMAKE_INSTALL_PREFIX=/mysqldata/mysql3307/ \-DMYSQL_DATADIR=/mysqldata/dirdata/mysql3307 \-DWITH_INNOBASE_STORAGE_ENGINE=  \-DENABLED_LOCAL_INFILE=  \-DMYSQL_TCP_PORT=  \-DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8-general_ci \-DMYSQL_UNIX_ADDR=/mysqldata/dirdata/mysql3307 /mysql.sock \-DMYSQL_USER=mysql3307 \-DWITH_DEBUG=[root@xuhost mysql- 5.5.9]# make[root@xuhost mysql- 5.5.9]# make install

Copy the configuration file

[root@xuhost mysql- 5.5.9]# cp support-files/my-medium.cnf /etc/my.cnf

Copy the Startup Script

[root@xuhost mysql- 5.5.9]# cp support-files/mysql.server /etc/init.d/mysqld[root@xuhost mysql- 5.5.9 ]# chmod  /etc/init.d/mysqld

Initialize the database (go to the installation directory)

[root@xuhost mysql5. 5.9 ]# ./scripts/mysql_install_db –user=mysql –ldata=/ var /mysql

Start Database

[root@xuhost mysql5. 5.9 ]# /etc/init.d/mysqld start

Myslq 5.5. Summary of compilation errors in later versions:

CMake Warning: The var iable, 'mysql _ user', specified manually, was not used during the generation.

You need to remove MYSQL_USER from the pre-compilation to make the pre-compilation successful!