centos下源码安装mysql-5.1.53

cdbubusmvl

0. 设置PATH
[iyunv@ldap-mysql-svn-trac ~]# export PATH="$PATH:/usr/man/mysql/bin"


1. 解压mysql的源码包mysql-5.1.53.tar.gz，切换到安装目录下
[iyunv@ldap-mysql-svn-trac mysql-5.1.53]# ./configure --prefix=/usr/man/mysql --sysconfdir=/usr/man/mysql --localstatedir=/usr/man/mysql/data --with-unix-socket-path=/usr/man/mysql/tmp/mysql.sock --with-charset=gbk --with-plugins=innobase --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static

#sysconfdir表示mysql的配置文件路径，localstatedir表示数据文件路径，socket配置和最后2

个属性主要用来提升性能

#如果要使用innodb引擎，记得加上--with-plugins=innobase

2. install
[iyunv@ldap-mysql-svn-trac mysql-5.1.53]# make
[iyunv@ldap-mysql-svn-trac mysql-5.1.53]# make install


3. config
[iyunv@ldap-mysql-svn-trac mysql-5.1.53]# cp /usr/man/mysql/share/mysql/my-medium.cnf/usr/man/mysql/my.cnf


4. 切换到mysql的bin目录下，run
[iyunv@ldap-mysql-svn-trac bin]#./mysql_install_db --basedir=/usr/man/mysql --


datadir=/usr/man/mysql/data


5. 复制/usr/man/mysql/libexec/mysqld到mysql的bin目录下，启动mysql服务
[iyunv@ldap-mysql-svn-trac bin]# cp /usr/man/mysql/libexec/mysqld /usr/man/mysql/bin


6. run mysql service
/usr/man/mysql/bin/mysqld_safe --ledir=/usr/man/mysql/bin --log-error=/usr/man/mysql/data/t.err --datadir=/usr/man/mysql/data --socket=/usr/man/mysql/tmp/mysql.sock --pid-file=/usr/man/mysql/bin/mysqld.pid &