Linux平台下MySQL 5.5的编译安装【RHEL5.4】
Linux平台下MySQL 5.5的编译安装【RHEL5.4】
目前各大门户网站均在一定程度上偏向MySQL的使用,加上阿里系倡导的去I/O/E运动,先前一直轻视MySQL的观点必须要改正下,况且做为一个数据库从业者,必须要熟悉2种以上的rdbms数据库,因而今后的学习重点依然是Oracle,MySQL则作为一个延伸方向!本文主要记录MySQL5.5版本在linux平台的编译安装过程,MySQL在5.1和5.5版本上存在比较大的差别,5.1之后提供了分区表的功能,5.5版本上默认的存储引擎改为innodb,5.1之前则是myisam
1:安装必要的rpm包,创建MySQL用户组,本文采用的操作系统平台为RHEL5.4
- [root@ www.bkjia.com ~]# grep -v '^#' /etc/yum.repos.d/base.repo |grep -v '^$'
- [base]
- name=base
- baseurl=file:///mnt/Server
- gpgcheck=0
- enable=1
- [root@ www.bkjia.com ~]# mount /dev/cdrom /mnt
- mount: block device /dev/cdrom is write-protected, mounting read-only
- [root@ www.bkjia.com ~]# yum -y install gcc gcc-c++ gcc-g77 autoconf automake \
- zlib* fiex** libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*
- [root@ www.bkjia.com ~]# id mysql
- uid=27(mysql) gid=27(mysql) groups=27(mysql)
2:下载cmake和mysql源码包,进行编译安装,mysql5.5版本需要使用cmake编译
- [root@ www.bkjia.com ~]# cd /usr/local/src/tarbag/
- [root@ www.bkjia.com tarbag]# wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
- [root@ www.bkjia.com tarbag]# wget http://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.25.tar.gz
- [root@ www.bkjia.com tarbag]# tar -zxvpf cmake-2.8.4.tar.gz -C ../software/
- [root@ www.bkjia.com tarbag]# tar -zxvpf mysql-5.5.25.tar.gz -C ../software/
- [root@ www.bkjia.com tarbag]# cd ../software/cmake-2.8.4/
- [root@ www.bkjia.com cmake-2.8.4]# ./configure --prefix=/usr/local/cmake2.8.4 && make && make install
- [root@ www.bkjia.com ~]# grep PATH .bash_profile
- PATH=$PATH:$HOME/bin:/usr/local/cmake2.8.4/bin:$PATH
- export PATH
- [root@ www.bkjia.com ~]# . .bash_profile
- [root@ www.bkjia.com ~]# cd /usr/local/src/software/mysql-5.5.25/
- [root@ www.bkjia.com mysql-5.5.25]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5.25 \
- -DMYSQL_DATADIR=/mydata \
- -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
- -DWITH_INNOBASE_STORAGE_ENGINE=1 \
- -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all \
- -DDEFAULT_CHARSET=utf8 \
- -DDEFAULT_COLLATION=utf8_general_ci \
- -DWITH_DEBUG=0
- [root@ www.bkjia.com mysql-5.5.25]# make && make install
3:初始化mysql服务
- [root@ www.bkjia.com mysql-5.5.25]# cp support-files/my-large.cnf /etc/my.cnf
- [root@ www.bkjia.com mysql-5.5.25]# cp support-files/mysql.server /etc/init.d/mysqld
- [root@ www.bkjia.com mysql-5.5.25]# chmod +x /etc/init.d/mysqld
- [root@ www.bkjia.com mysql-5.5.25]# chkconfig --add mysqld
- [root@ www.bkjia.com mysql-5.5.25]# sh ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.5.25/ --datadir=/mydata/
- [root@ www.bkjia.com mysql-5.5.25]# service mysqld start
- Starting MySQL...[ OK ]
- [root@ www.bkjia.com ~]# echo '/usr/local/mysql5.5.25/include/' >> /etc/ld.so.conf
- [root@ www.bkjia.com ~]# echo '/usr/local/mysql5.5.25/lib/' >> /etc/ld.so.conf
- [root@ www.bkjia.com ~]# ldconfig
|
评论暂时关闭