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

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