ICentOS5.5MySql5.1.49的安装、优化及安全设置.docxVIP

CentOS5.5 MySql 5.1.49的安装、优化及安全设置下载页面：/downloads/mysql/5.0.html#downloads到页面底部，找到Source downloads，这个是源码版本，下载第1个Tarballwget .tw/Downloads/MySQL-5.1/mysql-5.1.49.tar.gzMysql5.1.49版本真是速度滴就出来了。wget .tw/Downloads/MySQL-5.1/MySQL-server-community-5.1.49-1.rhel5.i386.rpmwget .tw/Downloads/MySQL-5.1/MySQL-client-community-5.1.49-1.rhel5.i386.rpm今天花了近一天的时间来安装mysql，终于在最后成功了。真是太折腾人了。至于为什么选用source code来安装而不选用rpm，主要是在网上查到rpm不能指定安装目录，这是我不喜欢的。 首先下载mysql-5.1.49.tar.gz -yum remove mysql //删除CentOS上自带的老版本mysql -groupadd mysql -useradd -g mysql mysql 在编辑MYSQL时：#./configure --prefix=/usr/local/mysql --with-charset=gb2312? --with-extra-charsets=all?执行后出现如下错误：checking for tgetent in -ltermcap… nochecking for termcap functions library… configure: error: No curses/termcap library found?解决方法：编译时加上路径即可解决，即#./configure --prefix=/usr/local/mysql --with-charset=gb2312 --with-extra-charsets=all?--with-named-curses-libs=/usr/lib/libncurses.so.5如果是Ubuntu，需要安装.sudo apt-get install libncurses5-dev如果Ubuntu上安装了VMwareTools-版本号.tar.gz则不需要安装libncurses5-dev,在编译时加上--with-named-curses-libs=/usr/lib/libncurses.so.5/bin/rm: cannot remove `libtoolT: No such file or directory错误在执行./configure 之前，先执行： # autoreconf --force --install # libtoolize --automake --force # automake --force --add-missing编译配置参数./configure –help 查看选项 ./configure \–prefix=/mysql \–localstatedir=/data \–sysconfdir=/mysql \–with-unix-socket-path=/mysql/mysql.sock \–with-charset=utf8 \–with-collation=utf8_general_ci \–with-extra-charsets=gbk,latin1 \–with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster,csv,federated \–without-debug \–enable-thread-safe-client \–enable-assembler \–enable-profiling \–with-mysqld-ldflags=-all-static \–with-client-ldflags=-all-static \–with-mysqld-user=mysql \–without-embedded-server \–with-server-suffix=-community \–with-tcp-port=3306执行需要10分钟左右说明：–prefix=/mysql \?# 安装目录–localstatedir=/data \?# 数据目录–sysconfdir=/mysql \?#f目录–with-unix-socket-path=/mysql/mysql.sock \?# socket文件目录–with-charset=utf8 \?# 默认字