新建目录
mkdir -p /data0/software
cd /data0/software
从官方网站获取源码包http://dev.mysql.com/
解压并安装
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar zxvf mysql-5.1.30.tar.gz
cd mysql-5.1.30/
./configure –prefix=/usr/local/mysql/ –enable-assembler –with-extra-charsets=complex –enable-thread-safe-client –with-big-tables –with-readline –with-ssl –with-embedded-server –enable-local-infile –with-innodb
make && make install
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
以mysql用户帐号的身份建立数据表
/usr/local/mysql/bin/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql
启动MySQL（最后的&表示在后台运行）
/bin/sh /usr/local/mysql/bin/mysqld_safe –defaults-file=/usr/local/mysql/my.cnf &
然后我执行下面命令启动mysql，出现以一错误信息
[root@localhost mysql-5.1.30]# /bin/sh /usr/local/mysql/bin/mysqld_safe –defaults-file=/usr/local/mysql/my.cnf
081221 11:29:18 mysqld_safe Logging to ‘/usr/local/mysql/data/localhost.err’.
081221 11:29:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
081221 11:29:19 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.pid ended
在my.cnf里面把
–skip-federated
变成
#–skip-federated
OK 解决
将mysql加入环境变量
ln -s /usr/local/mysql/bin/* /usr/bin/
设置mysql自启动
vi /etc/rc.d/rc.local
在文件的最后加上：
/usr/local/mysql/bin/mysqld_safe &