MySQL5.1升级5.6后,执行grant出错:ERROR 2013 (HY000): Lost connection to MySQL server during query【转载】
转载:
MySQL5.5升级5.6后,执行grant出错:ERROR 2013 (HY000): Lost connection to -mysql教程-数据库-壹聚教程网
http://www.111cn.net/database/mysql/79899.htm
MySQL 5.5 升级到 MySQL5.6,在什么都没有更改的情况下,直接将data放置到MySQL 5.6下运行,一开始就一切正常,但在新加一个数据库后,分配权限时,就出错了:
ERROR 2013 (HY000): Lost connection to MySQL server during query
一开始以为是连接不上socket,因为同时有看到错误:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
但查看之后,发现sock正常,没任何问题,然后就跑到官网下面看mysql 5.6升级指南,其中有这么一段:
After upgrading to a new version of MySQL, run mysql_upgrade (see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”). This program checks your tables, and attempts to repair them if necessary. It also updates your grant tables to make sure that they have the current structure so that you can take advantage of any new capabilities. (Some releases of MySQL introduce changes to the structure of the grant tables to add new privileges or features.)
mysql_upgrade does not upgrade the contents of the help tables. For upgrade instructions, see Section 5.1.10, “Server-Side Help”.
mysql_upgrade should not be used when the server is running with --gtid-mode=ON, since it may make changes in nontransactional system tables in the mysql database, many of which are MyISAM and cannot be changed to use a different storage engine. See GTID mode and mysql_upgrade.
那就明白了,执行一下:
mysql_upgrade -u root -p
执行完后,再执行grant语句,问题解决。
最新文章
- 在 MAC OS X 安装 ADB (Android调试桥)
- 【转】Backbone使用总结
- JDBC数据库编程基本流程
- javascript 原型及继承
- AOJ - 2224 Save your cat(最小生成树)
- B. Friends and Presents(Codeforces Round #275(div2)
- MongoDB详解学习历程
- Mason 简单笔记
- CCF系列之门禁系统(201412-1)
- 安卓打开File Explorer里面不显示内容
- jQuery获取节点和子节点文本的方法
- 比较python类的两个instance(对象) 是否相等
- laravel----------laravel5.3调度任务以及Artisan
- py3+urllib+re,轻轻松松爬取双色球最近100期中奖号码
- Codeforce使用方式
- C++中的this和Python的self对比
- spring c3po 连接mysql,sqlserver
- [翻译] 带有震动效果的 ShakingAlertView
- rsync: chroot No such file or directory (2)
- Http:设置 浏览器中MIME 类型