1、系统和软件环境
系统:CentOS 5.5 安装必要软件:
yum -y install gcc make bison
下载软件包: mysql-5.5.8.tar.gz cmake-2.8.3.tar.gz
安装cmake:
tar xzvf cmake-2.8.3.tar.gz
./configure --prefix=/usr
make&&make install
2、安装mysql
tar xzvf mysql-5.5.8.tar.gz
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_COMMENT=slevin \
-DWITH_DEBUG=OFF \
make&&make install
3、初始化数据库
cd /usr/local/mysql
useradd mysql -d /dev/null -s /sbin/nologin
chown -R root:mysql .
/usr/local/mysql/scripts/mysql_install_db --datadir=/data --user=mysql
chown -R mysql:mysql /data
cat support-files/my-innodb-heavy-4G.cnf | grep -v "#" | grep -v "^$" > /etc/my.cnf
echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
/etc/rc.d/init.d/mysqld start
4、清除多余的用户
drop user root@127.0.0.1;
drop user root@localhost.localdomain;
drop user ''@localhost.localdomain;
drop user ''@localhost;
drop user 'root'@'::1';