mysql升级报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
来源:互联网 发布:网络流行词汇及解释 编辑:程序博客网 时间:2024/06/05 13:30
一、问题:
mysql从5.1升级到5.6后,创建新用户,进行grant赋权的时候,报错:
ERROR 2013 (HY000): Lost connection to MySQL server during query
操作系统为:centOS6.5,原自带的版本为5.1.
二、分析
在网上搜到一帖子(http://www.111cn.net/database/mysql/79899.htm)
官网下面看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.
版本更新后,需要重新更新相关的表和权限信息。
三、处理
1)、执行:mysql_upgrade -u root -p
2)、重新执行grant语句
- mysql升级报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- ERROR 2013 (HY000): Lost connection to MySQL server during query
- MySQL升级后:ERROR 2013 (HY000): Lost connection to MySQL server during query
- MySQL error 2013 : Lost connection to MySQL server during query
- mysql执行大文件报错:Error Code: 2013. Lost connection to MySQL server during query
- mysql5.5一插入数据就提示ERROR 2013 (HY000): Lost connection to MySQL server during query
- Lost connection to MySQL server during query
- lost connection to mysql server during query
- MySQL 错误 2013 Lost connection to MySQL server during query
- Mysql 插入大数据量数据报错:Lost connection to MySQL server during query
- Mysql导入Sql文件时报Error Code: 2013 - Lost connection to MySQL server during query
- [Err] 2013 - Lost connection to MySQL server during query
- 2013 lost connection to mysql server during query
- 错误代码: 2013 Lost connection to MySQL server during query
- mysql5.5一插入数据就提示ERROR 2013 (HY000): Lost connection to MySQL server during query,且mysql服务自动关闭
- sql文件导入大批量数据时,报错:Lost connection to MySQL server during query
- mysqldump:Error 2013 Lost connection to MySQL server during query ‘table’ at ... rows
- ERROR 2013 (HY000): Lost connection to MySQL server的解决方法
- 爬虫框架Scrapy的第一个爬虫示例入门教程
- 二叉查找树(2) - 删除节点
- java中的深复制和浅复制
- HTTP报文格式说明
- 分数化小数(decimal)
- mysql升级报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- 【Java8】JDK8.0新特性—Lamda表达式
- Codeforces 549C. The Game Of Parity 博弈
- UIProgressView
- android SDK manager 无法获取更新版本列表
- IBM 3624 Customer PIN,Natural PIN,PIN Offset的相关内容
- Android自定义View——自定义搜索框(SearchView)
- 正则表达式 (1)
- 2015061505 - 代码分析之代码格式(2)