mysql 5.1原始碼安裝

進入解壓目錄，執行下面命令：

./configure --prefix=/usr/local/mysql/ --without-debug --without-bench --enable-thread-safe-client --enable-assembler --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=latin1 --with-extra-charset=ytf8,gbk --with-innodb --with-csv-storage-engine --with-federated-storage --with-mysqld-user=mysql --without-embedded-server --with-server-suffix=-community --with-unix-socket-path=/usr/local/mysql/sock/mysql.sock

3.編譯,安裝
命令:

make

make install

4.建立使用者和組.

groupadd mysql

useradd -g mysql mysql

5.進入mysql目錄.建立var目錄.並把./share/mysql/my-medium.cnf 拷到mysql目錄下並改名為my.cnf.

>mkdir var 

>mv share/mysql/my-medium.cnf my.cnf

6.配置my.cnf 

配置主要把安裝的目錄的那幾項開啟就行.

改動如下:

[client]
#password = your_password
port = 3306 
socket = /tmp/mysql3306.sock 

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql3306.sock

開啟下面幾項

innodb_data_home_dir = /usr/local/mysql/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir =  /usr/local/mysql/var/

7.安裝資料庫

命令:./bin/mysql_install_db --defaults-file=  /usr/local/mysql /my.cnf --user=mysql

說明:必須用引數--defaults-file指定my.cnf,否則系統用預設的/etc/my.cnf.

8.安裝完後,可以看到mysql/var目錄下有資料檔案,然後用下面命令設定許可權:

shell> chown -R root .
shell> chown -R mysql var
shell> chgrp -R mysql .

9.啟動資料庫.

./bin/mysqld_safe --defaults-file=  /usr/local/mysql/my
.cnf --user=mysql & 

10.進入資料庫.

./bin/mysql -u root  --defaults-file=  /usr/local/mysql/my.cnf

預設時沒有密碼,當然如果你刪除/etc/my.cnf,可以不要後面的--defaults-file= /usr/local/mysql/my.cnf

11.設為服務並自啟動.

對於設定為服務只要把mysql/share/mysql/mysql.server放到/etc/init.d/下改名為mysql

命令:

mv share/mysql/mysql.server /etc/init.d/mysql

chmod 775 /etc/init.d/mysql

chkconfig --add mysql

總結,這只是安裝了一個3306埠的mysql,如果要在裝一個msyql,步驟一樣,只要改動my.cnf檔案的內容.

[client]
#password = your_password
port = 3307
socket=/usr/local/mysql/sock/mysql.sock 

# The MySQL server
[mysqld]
port = 3307
socket=/usr/local/mysql/sock/mysql.sock