编译安装MYSQL的方法

通过编译安装MYSQL可以使服务器让MYSQL得到一定的优化，源码包不区分32位和64位版本。

# tar zxvf mysql-5.0.45.tar.gz
# cd mysql-5.0.45
# groupadd mysql
# useradd –g mysql mysql
#./configure –datadir=/var/lib –prefix=/usr/local/mysql –without-isam –with-raid –with-big-tables  –with-big-tables –without-debug –enable-thread-safe-client –with-client-ldflags=-all-static –with-extra-charsets=gbk

#cd /usr/local/mysql/bin/
# ./mysql_install_db –user=mysql –datadir=/data
# cp /var/lib/mysql/mysql.server /etc/rc.d/init.d/mysqld
#chown –R root .
# chown –R mysql /data
#chgrp –R mysql .
# chkconfig –add mysqld
# chmod +x /etc/rc.d/init.d/mysqld
# cp /var/lib/mysql/my-innodb-heavy-4G.cnf /etc/my.cnf
#service mysqld start      #—启动数据库
#cd /usr/local/mysql/bin
#./mysqldamin –uroot –p password ‘new’    #—设置ROOT用户的密码
Enter password:                         #—直接回车就可以了
Mysql> create database fire9;          #—创建数据库