ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
来源:互联网 发布:代理模式java有几种 编辑:程序博客网 时间:2024/06/13 08:08
1.因为用到递归,检查循环有没有重复创建connection,检查没有而去每一步数据库的操作都做了close;在频繁的点击链接时就出现这个错误,考虑到
mysql连接数的问题。
2.在my.ini的[mysqld]下添加max_connections=500,不过在运行一段时间后还是会出同样的错误看来问题并不是出在连接数上,在mysql的官网上找到了
这个bug的解决方案,原来是由于windows的socket关闭时的 TIME_WAIT造成的,需要修改下注册表在
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
下添加子项
Value Name: MaxUserPort
Data Type: REG_DWORD
Value: 65534
Value Name: TcpTimedWaitDelay
Data Type: REG_DWORD
Value: 30
修改完重启电脑,测试没发现这个问题了。
- ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
- [MySQL][ODBC 5.7 Driver]Can't connect to MySQL server on 'localhost' (10061)
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql长时间不用出现ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 常见问题:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- MySQL错误ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)的解决
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")
- ERROR 2003 (HY000):CAN’T CONNECT TO MYSQL SERVER ON ‘LOCALHOST’ (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 解决办法
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- VB工程---百例100--获取键盘类型
- RPC/XDR/NFS系列之----远程过程调用
- POJ 1222 EXTENDED LIGHTS OUT 枚举 || 高斯消元
- 比较两个对象
- Size Balanced Tree(SBT) 类模板C++实现(持续更新)
- ERROR [HY000] [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)
- 程序员编程艺术:第八章、从头至尾漫谈虚函数
- Icinga Installation
- 栈--求迷宫所有解
- Ubuntu11.10编译内核:make xconfig错误
- zoj 2704 Brackets
- PuTTy 本地文件上传/下载
- mount a LVM disk
- 能让大脑不衰老的六大习惯