centos下mysql 源码版 安装

解压安装程序
# cd /usr/local/software/
# tar zxvf mysql-5.0.67.tar.gz
# cd mysql-5.0.67
# mkdir /usr/local/mysql
# mkdir /usr/local/mysql/data

配置mysql
# ./configure --prefix=/usr/local/mysql --sysconfdir=/usr/local/mysql/data --localstatedir=/usr/local/mysql/data
#make
#make install
安装完以后要初始化数据库，当然你是升级的话不用做这步；
# cd /usr/local/mysql/bin/
# ./mysql_install_db
建立 mysql 用户；
# /usr/sbin/useradd -M -o -r -d /usr/local/mysql/data -s /bin/bash -c "MySQL Server" -u 27 mysql
设置权限；
# chown -R mysql:mysql /usr/local/mysql/data
# chmod 750 /usr/local/mysql/data
# chown -R mysql:mysql /usr/local/mysql
# chmod -R 750 /usr/local/mysql

复制脚本 添加服务
# cd /usr/local/software/mysql-5
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
# /sbin/chkconfig --add mysqld
# /sbin/chkconfig mysqld on
拷贝配置文件
# cp support-files/my-medium.cnf /usr/local/mysql/data/my.cnf
设置默认编码
在/usr/local/mysql/data/my.cnf中[mysqld]和[client]下面增加如下设置：
default-character-set = utf8
好了，至此mysql安装完毕，可以起动mysql服务
# /etc/rc.d/init.d/mysqld start
or
# service mysqld start(推荐)