:: compiling mysql on centos

:: what is
please take a look at this.

:: installing dependency package

[ root:mysql-5.1.37 ]# yum install gcc gcc-c++ make libtool automake libtermcap-devel

:: download mysql-5.1.37 source

[ root: ~]# mkdir download
[ root: ~] # cd download/
[ root:downlad ]# wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.37.tar.gz/from/ftp://ftp.inria.fr/pub/MySQL/
[ root:downlad ]# tar -xzf mysql-5.1.37.tar.gz

:: build and install

[ root:downlad ]# cd mysql-5.1.37
[ root:mysql-5.1.37 ]# groupadd mysql
[ root:mysql-5.1.37 ]# useradd -g mysql mysql
[ root:mysql-5.1.37 ]# ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --with-pthread
[ root:mysql-5.1.37 ]# make && make install

:: configuring mysql

[ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysql_install_db --user=mysql
[ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysqld_safe --user=mysql &

:: testing

[ root:mysql-5.1.37 ]# /usr/local/mysql/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

:: links
+ GoogleLinux
+ BlacKonsole