MySQL 5.5 -> 5.6

在LNMP(一键安装包)下的MySQL升级

wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz
tar zxf mysql-5.6.14.tar.gz
# 这些是LNMP安装时带上的参数，这里也加上了
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1
make
# 然后结束mysql
/root/lnmp stop
make install
# mysql启动
/root/lnmp start
# 升级
/usr/local/mysql/bin/mysql_upgrade -u root -p{密码}
$ mysql重启
/root/lnmp restart