mysql編譯安裝

# wrote by:dywer  Nov 26 08 in BeiJing

#tar mysql-5.0.51b.tar.gz # Mysql源碼包名對應

#cd mysql-5.0.51b

#./configure --prefix=/usr/local/mysql \

#--localstatedir=/usr/local/mysql/data \

#--with-mysqld-ldflags=-all-static \

#--with-charset=gbk --enable-assembler \

#--with-extra-charsets=all --sysconfdir=/etc && make && make isntall

#useradd mysql

cd /usr/local/mysql   # 轉到MYSQL目錄

#cp support-files/my-medium.cnf /etc/my.cnf

bin/mysql_install_db   # 初始化資料庫

########################################

chown -R root:mysql .   # 修改權限

chown -R mysql data

chmod 750 -R .

# copy配置檔案,有large,medium,small三個環境下的,根據機器性能選擇,

# 如果負荷比較大,可修改裡面的一些變量的記憶體使用值

###############################################################

#cp support-files/mysql.server /etc/init.d/mysqld # 複制啟動腳本

chmod 700 /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig --level 345 mysqld on

service mysqld start

netstat -atln |grep 3306

#######################################