在CentOS上编译安装mysql-5.6.10

来源：互联网发布：java的优势和缺点编辑：程序博客网时间：2024/06/04 17:08

1.卸载原有mysql
[root@localhost ~]# rpm -qa|grep mysql
mysql-libs-5.1.47-4.el6.x86_64

[root@localhost ~]rpm -e --nodeps mysql-libs-5.1.47-4.el6.x86_64

2.安装必要软件包
[root@localhost ~]yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake

3.创建mysql用户及用户组：
[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -g mysql mysql

4.下载源码并安装：
[root@localhost mysql]wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz
[root@localhost mysql]tar -zxvf mysql-5.6.10.tar.gz
[root@localhost mysql]cd mysql-5.6.10
[root@localhost mysql]cmake .
[root@localhost mysql]make && make install
[root@localhost mysql]#chown -R mysql:mysql /usr/local/mysql
[root@localhost mysql]#cd /usr/local/mysql/scripts
[root@localhost mysql]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@localhost mysql]#cd /usr/local/mysql/support-files
[root@localhost mysql]#cp mysql.server /etc/rc.d/init.d/mysql
[root@localhost mysql]#cp my-default.cnf /etc/my.cnf
[root@localhost mysql]#chkconfig --add mysql
[root@localhost mysql]#chkconfig mysql on
[root@localhost ~]# vi /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/lib
[root@localhost ~]# source /root/.bash_profile
[root@localhost mysql]# service mysql start
Starting MySQL.