Q:MySQL还原备份出错 ERROR 2005(HY000) unkonw MySQL server host
A:新建数据库utf8
mysql -u root -p --default-character-set=utf8
use test;
set names utf8;
source e:\123\123.sql;
调大了 connect_timeout 和 wait_timeout的值
show global variables like ‘%timeout‘;
set global INTERACTIVE_TIMEOUT=2880000;
set global WAIT_TIMEOUT=2880000;
SQL语句太大了,查看一下允许的最大包大小:
show global variables like ‘max_allowed_packet‘;
value/1024/1024为现在大小,修改参数值为256M(1024*1024*256)
set global max_allowed_packet=1073741824;
参考链接
https://www.cnblogs.com/ivictor/p/5979731.html
https://blog.csdn.net/fdipzone/article/details/51974165
mysql升级5.6至5.7
参考链接
https://www.cnblogs.com/java-123/p/10624600.html
相关文章
- 08-14Navicat for MySQL打开链接时出错错误为:2005 - Unknown MySQL server host 'localhost'(0)?
- 08-14MySQL5.1升级5.6后,执行grant出错:ERROR 2013 (HY000): Lost connection to MySQL server during query【转载】
- 08-14如何修复ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)。
- 08-14启动MySQL报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (1006
- 08-14解决ERROR 2003 (HY000): Can't connect to MySQL server on
- 08-14linux安装MySQL后输入mysql显示 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- 08-14解决mysql登录报错:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- 08-14mysql出错ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- 08-14ERROR 2003 (HY000): Can't connect to MySQL server on 'ip地址' (110)
- 08-14【转】ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.165' (113)