最近习惯用 Mysql 5.7的 Json 字段类型了,而低于5.7版本的Mysql都不支持JSON字段类型。
升级Mysql
安装最新的Mysql的Yum源
安装步骤1的rpm包,这样就安装好了Mysql最新的Yum源地址库:
# rpm -ivh mysql57-community-release-el6-11.noarch.rpmrpm ivh
查看当前mysql版本和Yum源中最新的mysql版本(是否满足需求):
# yum list|grep mysql-community
执行升级命令
# yum update mysql-server
遇到的问题
启动Mysqld失败
错误信息
mysql错误日志:
[ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
根据提示执行mysql_upgrade,继续报错:
[root]# mysql_upgrade
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
错误原因
Mysql版本升级,却未执行mysql_upgrade所致。