centos安装mysql5.6tar_CentOS-6.4安装MySQL-5.6

下面介绍下在CentOS-6.4安装MySQL-5.6.14。

[1]下载源码包[root@PHPHa ~]# http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz

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

[3]编译安装[root@PHPHa ~]# groupadd mysql

[root@PHPHa ~]# useradd -r -g mysql mysql

[root@PHPHa ~]# tar -zxvf mysql-5.6.14.tar.gz

[root@PHPHa ~]# cd mysql-5.6.14

[root@PHPHa ~]# cmake .

[root@PHPHa ~]# make && make install

[root@PHPHa ~]# chown -R mysql.mysql /usr/local/mysql

[root@PHPHa ~]# cd /usr/local/mysql/scripts

[root@PHPHa ~]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

[root@PHPHa ~]# cd /usr/local/mysql/support-files

[root@PHPHa ~]# cp mysql.server /etc/rc.d/init.d/mysql

[root@PHPHa ~]# cp my-default.cnf /etc/my.cnf

[root@PHPHa ~]# chkconfig --add mysql

[root@PHPHa ~]# chkconfig mysql on

[root@PHPHa ~]# service mysql start

[root@localhost mysql]# service mysql start

Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.pid).

[root@PHPHa ~]# ps -ef | grep mysqld

[root@PHPHa ~]# root 19897 19401 0 15:04 pts/0 00:00:00 grep msyqld

[root@PHPHa ~]# kill 19897

[root@PHPHa ~]# service mysql start

[root@PHPHa ~]# /usr/local/mysql/bin/mysql -u root -p -S /tmp/mysql.sock

Enter password:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

Query OK, 0 rows affected (0.00 sec)