1.下載Mysql的社區(qū)版 mysql-5.0.51b.tar.gz
2. 解壓縮：
??? > tar zxvf mysql-5.0.51b.tar.gz
??? > cd mysql-5.0.51b
3. configure:
??? > CFLAGS="-O3" CXX=gcc CXXFLAGES="-O3 -felide-constructors \
??? > -fno-exceptions -fno-rtti" \
??? > ./configure --prefix=/usr/local/mysql \
??? > --enable-assembler \
??? > --with-mysqld-ldflags=-all-static \
??? > --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
??? > --with-client-ldflags=-all-static \
??? > --with-extra-charsets=all
4. make & install
??? > make
??? > sudo make install
5. 增加用戶
??? > sudo groupadd mysql
??? > sudo useradd -g mysql mysql
6. 拷貝初始配置文件和啟動(dòng)腳本
??? > sudo cp support-files/my-medium.cnf /etc/my.cnf
??? > sudo cp support-files/mysql.server /etc/init.d/mysql
??? > sudo chmod a+x /etc/init.d/mysql
7. 改變安裝目錄權(quán)限
??? > cd /usr/local/mysql
??? > sudo chown -R mysql .
??? > sudo chgrp -R mysql .
8. 初始化權(quán)限表
??? > sudo bin/mysql_install_db --user=mysql
9. 再次限制訪問(wèn)權(quán)限
??? > sudo chown -R root .
??? > sudo chown -R mysql var
10. 修改啟動(dòng)腳本配置
??? > sudo vi /etc/my.cnf
??? 添加啟動(dòng)用戶和路徑
??? [mysqld］
??? user=mysql
??? port=3306
??? socket=/var/tmp/mysql.sock
??? datadir=/usr/local/mysql/var
???
??? [mysql.server]
??? basedir=/usr/local/mysql
11. 運(yùn)行測(cè)試
??? > sudo /etc/init.d/mysql start
??? > bin/mysql
??? mysql> show databases
??? ...
??? > sudo /etc/init.d/mysql stop
??? NOTE: 配置過(guò)程中缺少PACKAGE － curses
??? > sudo apt-get intall libncurses5-dev
??? (search from: http://packages.debian.org)