由于需要支持utf8mb4,mysql需要升级,那么需要重新安装5.5及以上的版本,先备份好数据。
环境为:2.6.32-504.el6.x86_64
1.停止mysql并删除低版本的mysql
yum remove mysql mysql-*
2.Webtatic EL6 for CentOS/RHEL 6.x
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm
3.安装mysql
yum install mysql55w mysql55w-server
4.启动
service mysqld start
5.修改密码
默认是没有密码的,直接mysql -uroot -p,空密码进入mysql
mysql> use mysql;
mysql> update user set password=PASSWORD("ciika") where User='root';
mysql> flush privileges;
mysql_upgrade -u root -p
参考:
https://webtatic.com/packages/mysql55/