CentOS6.4安装mysql5.6.14

1、 安装确保以下系统相关库文件
yum –y install gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libmcrypt* libtool*
2.安装编译环境和需要make的内核环境包ncurses-devel和bison，用yum安装
yum  install    gcc
yum  install    gcc-c++
yum install ncurses-devel
yum install bison
3.建立相应的安装需要的目录

mkdir  -p  /var/mysql/data

4.下载需要的软件包http://www.linuxfromscratch.org/blfs/view/svn/server/mysql.html中可以找到 找到连接后用下面的命令获取:

 

http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.6/

 

命令如下

wget http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.6/mysql-5.6.44.tar.gz

wget http://www.cmake.org/files/v2.8/cmake-2.8.12.tar.gz

5.解压安装cmake
tar  zxvf  cmake-2.8.4.tar.gz
cd   cmake-2.8.4
./bootstrap
gmake && gmake install
6.解压安装第一个mysql
tar zxvf   mysql-5.6.44.tar.gz
cd mysql-5.6.44
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=latin1 \
-DDEFAULT_COLLATION=latin1_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=latin1,gbk \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/var/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
make && make install
cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
cp  support-files/mysql.server    /etc/init.d/mysql
vi  /etc/init.d/mysql
修改conf=/usr/local/mysql/my.cnf
保存退出
chmod  755  /etc/init.d/mysql
chkconfig  ---add  mysql
chkconfig   mysql  on
groupadd   mysql
useradd  -g  mysql  mysql
chmod +w   /usr/local/mysql
chmoed +w  /var/mysql/data
chown  -R  mysql:mysql   /user/local/mysql
chown  -R  mysql:mysql  /var/mysql/data
/usr/local/mysql/scripts/mysql_install_db
--defaults-file=/usr/local/mysql/my.cnf
--basedir=/usr/local/mysql
--datadir=/var/mysql/data
--user=mysql
/usr/local/mysql/bin/mysqld_safe    &
service   mysql   start    
第一个安装到此完成
第二个安装注意另外找一个目录重新解压mysql压缩包
tar zxvf   mysql-5.6.44.tar.gz
cd mysql-5.6.44
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql2 \
-DMYSQL_UNIX_ADDR=/tmp/mysql2.sock \
-DDEFAULT_CHARSET=latin1 \
-DDEFAULT_COLLATION=latin1_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=latin1,gbk \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/var/mysql/data2 \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3307
make && make install
cp support-files/my-medium.cnf /usr/local/mysql2/my.cnf
cp  support-files/mysql.server    /etc/init.d/mysql2
vi  /etc/init.d/mysql2
修改conf=/usr/local/mysql2/my.cnf
保存退出
chmod  755  /etc/init.d/mysql2
chkconfig  ---add  mysql 2
chkconfig   mysql2  on
chmod +w   /usr/local/mysql2
chmoed +w  /var/mysql/data2
chown  -R  mysql:mysql   /user/local/mysql2
chown  -R  mysql:mysql  /var/mysql/data2
 /usr/local/mysql2/scripts/mysql_install_db
--defaults-file=/usr/local/mysql2/my.cnf
--basedir=/usr/local/mysql2
--datadir=/var/mysql/data2
--user=mysql
/usr/local/mysql2/bin/mysqld_safe    &
service   mysql2   start