本文介绍 OceanBase 数据库 MySQL 模式下与服务器的连接断开并报ERROR 2013错误的处理方法。 问题现象 成功连接数据库后,会话空闲较长一段时间再执行查看ordr表数据的 SQL 语句,报连接断开的错误。 obclient [test]> SELECT * FROM ordr; ERROR 2013 (HY000): Lost connection to MySQL server during query ...
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0 这个测试的MySQL位于阿里云Kubernetes(K8s)中Docker容器里面,而且在远程连接MySQL出现上面错误的时候,Docker也会出现下面错误。 一般出现“ERROR 2013 (HY000): Lost connection to MySQL server at 'reading ...
mysqldump+error2013()+increaseTimeout()+useSingleTransaction()+increasePacketSize() 结论 通过上述方法,我们可以有效解决mysqldump error 2013的问题,确保成功备份数据库。在备份数据库时,我们可以根据具体情况选择适合的解决方法,避免出现连接断开导致的错误。希望本文能够帮助到遇到相同问题的读者,顺利完成数据库备份操作。
MySQLERROR2013（HY000）错误解决⽅法 当通过 TCP/IP 连接 MySQL 远程主机时，出现 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104 。如果是在linux shell命令⾏中直接打 mysql 命令，能够顺利连上 MySQL，执⾏查询语句也⽐较正常，但...
今天长生诀用Navicat连接数据库出现2013错误,然后百度了一下发现很少人提起这个 由于MySQL数据库是手工安装的,而且外网权限也开了死活连不上,最后折腾了一下就解决了 解决方法: 修改MySQL数据库配置文件etc/my.cnf 在[mysqld]最下面添加 skip-name-resolve ...
SQL Error (2013): Lost connection to MySQL server at 'waiting for initial,远程服务器的操作系统:Ubuntu本地:navicat+win10连接名:随意填写主机名:localhost端口:3306用户名:连接电脑的数据库的用户名密码:连接电脑的数据库的密码主
临时性错误:ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 2 #24 Closed zqdai opened this issue Sep 13, 2016· 11 comments Comments zqdai commented Sep 13, 2016 该错误在用自带的test tool时出现,或者在命令行操作很快的时候就会...
MySQL:readinginitialcommunication packet问题解决方法LostconnectiontoMySQLserverat ‘readinginitial.../etc/hosts.allow 加mysqld : ALL : ALLOW mysqld-max : ALL :ALLOW 其它网友的补充:mysql教程 ‘readinginitialcommunication...代码:2013错误:lostconnectiontomysqlserverat ‘re...
ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> mysql> mysql> mysql> select * from newdept; -> // ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 1 Current database: nbio ...
Re: ERROR 2013 (HY000): Lost connection to MySQL server during query. Sharath Chandra Karnati October 21, 2018 10:49PM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in ...