1. 下載"MySQL-standard-5.0.27-linux-i686-icc-glibc23.tar.gz"，推薦ICC版本，據稱比GCC性能提高10-20%

2. 復制到/usr/local/，解壓：tar zxvf mysql-standard-5.x....tar.gz

3. 添加用戶和組mysql：

groupadd mysql

useradd -g mysql mysql

4. 創建符號連接：/usr/local # ln -s mysql-standard-5.x... mysql

5. cd mysql，當前目錄改為/usr/local/mysql/

6. 運行腳步初始化數據庫：./scripts/mysql_install_db --user=mysql

7. 設置權限：

/usr/local/mysql # chown -R root .

/usr/local/mysql # chown -R mysql data

/usr/local/mysql # chgrp -R mysql

8. 根據需要創建并修改/etc/my.cnf，參考配置：

[mysqld]

# 設置默認為INNODB表，支持事務：

default-storage-engine=INNODB

# 設置默認的字符集：

default-character-set=utf8

# 禁用bdb：
http://m.survivalescaperooms.com
skip-bdb

9. 啟動MySQL：

/usr/local/mysql/bin # ./mysqld_safe --user=mysql &

10. 初始化root口令：

/usr/local/mysql/bin # ./mysqladmin -u root -p passWord "password-of-root"

Enter password: <輸入舊口令，直接按Enter>

11. 以root登錄創建數據庫：

/usr/local/mysql # ./mysql -u root -p

Enter password: password-of-root

創建一個新用戶：

mysql> create user test identified by 'test-password';

創建一個新數據庫：

mysql> create database testdb;

賦予test用戶從localhost訪問testdb的權限：

mysql> grant all on testdb.* to test@localhost;

停止MySQL服務器：

/usr/local/mysql/bin # ./mysqladmin -u root -p shutdown

Enter password: password-of-root

STOPPING server from pid file /usr/local/mysql/data/debian.pid

xxx mysqld ended

http://blog.csdn.net/asklxf/archive/2007/02/20/1512116.aspx