1、下载mysql5.5.X对应的linux 平台版本：
???????? 官网： http://dev.mysql.com/downloads/os-linux.html ，选择对应的32或者64位平台版本。
???????? 通过个人博客 下载：? http://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.5.3-m3.tar.gz

?

 wget  http://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.5.3-m3.tar.gz

??? 现假设mysql文件下载在/data0/soft目录下：

?

[root@local soft]# ll
总用量 23044
-rw-r--r--. 1 root root 23595610 9月  24 18:46 mysql-5.5.3-m3.tar.gz
[root@local soft]# pwd
/data0/soft

?

2、添加mysql管理的linux账户：

?

groupadd mysql;
useradd -g mysql mysql;

?

3、编译安装，注意编译选项：

?

cd /data0/soft/mysql-5.5.3-m3/
./configure --prefix=/usr/local/webserver/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg
make && make install
chmod +w /usr/local/webserver/mysql




chown -R mysql:mysql /usr/local/webserver/mysql




cd ../

?? prefix是数据库安装的目录，不然数据库默认安装到/usr/下各个角落。with-extra-charsets可以为complex /all /utf-8 / gbk? ,with-plugins添加实际mysql运行时需要的mysql插件。

?

?

4、创建mysql数据、日志文件存放目录：

mkdir -p /data0/mysql/3306/data/
mkdir -p /data0/mysql/3306/binlog/
mkdir -p /data0/mysql/3306/relaylog/
chown -R mysql:mysql /data0/mysql/

?

5、创建初始化数据库数据：

/usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/data0/mysql/3306/data --user=mysql

?

6、创建mysql配置文件：

?

vi /data0/mysql/3306/my.cnf

?添加如下配置文件：

[client]
character-set-server = utf8
port    = 3306
socket  = /tmp/mysql.sock

[mysqld]
character-set-server = utf8
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
user    = mysql
port    = 3306
socket  = /tmp/mysql.sock
basedir = /usr/local/webserver/mysql
datadir = /data0/mysql/3306/data
log-error = /data0/mysql/3306/mysql_error.log
pid-file = /data0/mysql/3306/mysql.pid
open_files_limit    = 10240
back_log = 600
max_connections = 5000
max_connect_errors = 6000
table_cache = 614
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 300
#thread_concurrency = 8
query_cache_size = 512M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
default-storage-engine = MyISAM
thread_stack = 192K
transaction_isolation = READ-COMMITTED
tmp_table_size = 246M
max_heap_table_size