CentOS-6.4安装MySQL-5.6

# blog.phpha.com
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz
# blog.phpha.com

# blog.phpha.com
yum -y install  gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake
# blog.phpha.com

# blog.phpha.com
groupadd mysql
useradd -r -g mysql mysql
tar -zxvf mysql-5.6.14.tar.gz
cd mysql-5.6.14
cmake .
make && make install
chown -R mysql.mysql /usr/local/mysql
cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
cd /usr/local/mysql/support-files
cp mysql.server /etc/rc.d/init.d/mysql
cp my-default.cnf /etc/my.cnf
chkconfig --add mysql
chkconfig mysql on
service mysql start
service mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.pid).
ps -ef | grep mysqld
root     19897 19401  0 15:04 pts/0    00:00:00 grep msyqld
kill 19897
service mysql start
/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)
# blog.phpha.com