学步园

开始安装MySQL:

# cd /

# mkdir home/mysql

# cd home/mysql

# mkdir res

把mysql-5.1.51.tar.gz下载到/home/mysql/res

解压源代码文件及添加用户

# cd /home/mysql/res

# groupadd ShiPin

# useradd -g ShiPin hbsp

设置用户口令为_2013HanBang

# passwd hbsp

# tar zxvf mysql-5.1.51.tar.gz

编译、链接、安装

# cd mysql-5.1.51

# vim /etc/yum.conf 注释此项即可“#exclude=kernel*”

# yum -y install automake (可选，如果已经安装就不用执行)

# yum -y install libtool (可选，如果已经安装就不用执行)

# sh BUILD/autorun.sh

# yum -y install gcc*

# yum -y install gcc-*

# yum -y install make gcc

# yum -y install libtermcap-devel

# ./configure --prefix=/home/mysql/mysql --with-charset=utf8 --with-extra-charsets=all --enable-assembler --with-unix-socket-path=/home/mysql/mysql/tmp/mysql.sock --without-debug --with-mysqld-user=hbsp --with-plugins=all CFLAGS="-O4" CXX=gcc CXXFLAGS="-O4
-felide-constructors -fno-exceptions -fno-rtti" --with-zlib-dir=bundled

# make

# make install

--with-zlib-dir=bundled(可选，如果已经安装zlib-devel包就不用)

--with-plugins=sphinx(可选)

复制配置和启动文件

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

# cp support-files/mysql.server /home/mysql/mysql/bin/mysql.server

# cd /home/mysql/mysql/bin

# chmod +x mysql.server

# cp mysql.server /etc/rc.d/init.d/mysql.server

初始化

# ./mysql_install_db --user=hbsp

# chown hbsp.ShiPin /home/mysql/mysql/var

# chmod +wr /home/mysql/mysql/var

# chown -R hbsp:ShiPin /home/mysql/mysql

# chown -R hbsp:ShiPin /home/mysql/mysql/*

# ./mysql.server start

# ./mysql -uroot -p

mysql> use mysql;

mysql> update user set Host='%',Password=password('_2013HanBang') where Host='127.0.0.1';

mysql> update user set Password=password('_2013HanBang') where user='root';

mysql> flush privileges;

mysql> quit;

# ./mysql.server stop

设置为后台服务

# /sbin/chkconfig --del mysql.server

# /sbin/chkconfig --add mysql.server