1.下載Mysql的社區版 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. 拷貝初始配置文件和啟動腳本
??? > 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. 改變安裝目錄權限
??? > cd /usr/local/mysql
??? > sudo chown -R mysql .
??? > sudo chgrp -R mysql .
8. 初始化權限表
??? > sudo bin/mysql_install_db --user=mysql
9. 再次限制訪問權限
??? > sudo chown -R root .
??? > sudo chown -R mysql var
10. 修改啟動腳本配置
??? > sudo vi /etc/my.cnf
??? 添加啟動用戶和路徑
??? [mysqld]
??? user=mysql
??? port=3306
??? socket=/var/tmp/mysql.sock
??? datadir=/usr/local/mysql/var
???
??? [mysql.server]
??? basedir=/usr/local/mysql
11. 運行測試
??? > sudo /etc/init.d/mysql start
??? > bin/mysql
??? mysql> show databases
??? ...
??? > sudo /etc/init.d/mysql stop
??? NOTE: 配置過程中缺少PACKAGE - curses
??? > sudo apt-get intall libncurses5-dev
??? (search from: http://packages.debian.org)