1、设置GCC编译参数

CHOST="i686-pc-linux-gnu"
CFLAGS="-O3 -msse2 -mmmx -Wall -W -mfpmath=sse -mcpu=pentium-m -march=pentium-m -pipe -fomit-frame-pointer"
CXXFLAGS="-O3 -msse2 -mmmx -Wall -W -mfpmath=sse -funroll-loops -mcpu=pentium-m -march=pentium-m -pipe -fomit-frame-pointer"

2、修改mysql 客户端最大连接数

vi sql/mysqld.cc
搜索找到下面一行：
{"max_connections", OPT_MAX_CONNECTIONS,
"The number of simultaneous clients allowed.", (gptr*) &max_connections,
(gptr*) &max_connections, 0, GET_ULONG, REQUIRED_ARG, 100, 1, 16384, 0, 1,
0},
将其中的100改为1500, 当然小点也可以，根据你的需要来，不建议改的太大。
{"max_connections", OPT_MAX_CONNECTIONS,
"The number of simultaneous clients allowed.", (gptr*) &max_connections,
(gptr*) &max_connections, 0, GET_ULONG, REQUIRED_ARG, 1500, 1, 16384, 0, 1,
0},
保存

3、安装Mysql

# ./configure --prefix=/usr/local/mysql \
--localstatedir=/var/lib/mysql \
--with-comment=Source \
--with-server-suffix=-enterprise-gpl \
--with-mysqld-user=mysql \
--without-debug \
--with-big-tables \
--with-charset=gbk \
--with-collation=gbk_chinese_ci \
--with-extra-charsets=all \
--with-pthread \
--enable-static \
--enable-thread-safe-client \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--enable-assembler \
--without-innodb \
--without-ndb-debug \
--without-isam \
--enable-local-infile \
--with-readline \
--with-raid

# make && make install

# groupadd mysql

# useradd -g mysql -d /dev/null -s /sbin/nologin mysql

# adduser -g mysql -d /dev/null -s /sbin/nologin mysql

# cd /usr/local/mysql/

# bin/mysql_install_db --user=mysql

# chown -R root:mysql .

# chown -R mysql:mysql /var/lib/mysql

# cd share/mysql

# cp my-medium.cnf /etc/my.cnf

# cp mysql.server /etc/rc.d/init.d/mysqld

# chmod 755 /etc/rc.d/init.d/mysqld

# chkconfig --add mysqld

4、添加LIB PATH

# echo "/usr/local/mysql/lib" >> /etc/ld.so.conf && ldconfig

5、启动Mysql

# /etc/rc.d/init.d/mysqld start

或者

# service mysqld start

6、设置Mysql的root密码

bin/mysqladmin -u root password 123456

修改root密码

mysql> USE mysql;

mysql> UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root’;

mysql> FLUSH PRIVILEGES;

7、设置root远程登录

# mysql -u root -p 123456

mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' identified by '123456' ;

8、关闭Mysql

# /etc/rc.d/init.d/mysqld stop

或者

# service mysqld stop

9、设置中文字符集

vi /etc/my.cnf

在[client]下面增加一行:
[client]
default-character-set = gbk

在[mysqld]下面增加三行:
[mysqld]
default-character-set = gbk
default-collation     = gbk_chinese_ci
init_connect          = 'SET NAMES gbk'

在[mysql]下面增加一行:
[mysql]
default-character-set = gbk