centos 5.5 编译安装mysql 5.5.11

1.准备
下载 mysql-5.5.11.tar.gz
2.环境
yum install ncurses-devel
yum install bison
yum install chkconfig
yum install gcc
yum install gcc-c++
mkdir /usr/mysql-5.5.11
mkdir /data/mysql
mkdir /usr/install/
3.安装CMake
cd /usr/install
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./configure
make && make install
4.源码编译
cd /usr/install/
tar xzvf mysql-5.5.11.tar.gz
cd mysql-5.5.11
cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql-5.5.11 -DMYSQL_DATADIR=/data/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DMYSQL_USER=mysql -DWITH_DEBUG=0
make && make install
5.安装数据库
groupadd mysql
useradd -r -g mysql mysql
cd /usr/mysql-5.5.11
chown -R mysql:mysql .
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
vi /etc/my.cnf
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
[mysql]
character-set-client=utf8#修改my.cnf必须在初始化数据库之前
scripts/mysql_install_db --user=mysql --basedir=/usr/mysql-5.5.11 --datadir=/data/mysql
5.设置密码
service mysqld start
ln -s /usr/mysql-5.5.11 /usr/mysql
/usr/mysql/bin/mysql
mysql > use mysql;
mysql > update user set password=Password('000000') where user='root';
mysql > flush privileges;
附删除mysql5.5.11的方法
rm -rfv /data/mysql/*
rm -rfv /etc/my.cnf
rm -rfv /etc/init.d/mysqld
rm -rfv /usr/mysql-5.5.11/*
rm -rfv /usr/install/mysql-5.5.11/*

延伸阅读