Can't connect to MySQL server on (99) 解法
来源:互联网 发布:淘宝类目排名查询 编辑:程序博客网 时间:2024/06/09 21:21
转自:http://blog.longwin.com.tw/2013/06/mysql-connect-error-99-resolve-2013/
追查到的主因在於 Connection 太多, 於是 TCP (Port) 不夠用, 於是就會出現此錯誤訊息, 解法如下:
先查看系統預設值
- $ sudo sysctl -a | grep tcp_tw
net.ipv4.tcp_tw_recycle = 0
net.ipv4.tcp_tw_reuse = 0 - $ sudo sysctl -a | grep tcp_syncookies
net.ipv4.tcp_syncookies = 1 - $ sudo sysctl -a | grep tcp_fin_timeout
net.ipv4.tcp_fin_timeout = 60
解法: (於 Server 設定即可)
- vim /etc/sysctl.conf
net.ipv4.tcp_syncookies =1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle =1
net.ipv4.tcp_fin_timeout= 5 - sudo sysctl -p # 讓設定能動, -p, --load[=<file>] read values from file
相關網頁
- MySQL Lists: mysql: Re: error 99(?) : can't connect to MySQL server
- Are PHP persistent connections evil ? - 下述摘錄自此文:
On Linux you can adjust “/proc/sys/net/ipv4/ip_local_port_range” to get more local ports available and “/proc/sys/net/ipv4/tcp_fin_timeout” to reduce recycle delay.
- 關於流量升高導致TIME_WAIT增加,MySQL連接大量失敗的問題 « 搜索技術博客-淘寶
0 0
- Can't connect to MySQL server on (99) 解法
- Can't connect to MySQL server on
- Mysql:Can't connect to MySQL server on ‘localhost' (10061)
- [mysql] Can't connect to mysql server on '127.0.0.1'
- MySql -- Can't connect to MySQL server on 'localhost' (10061)
- MySQL异常:Can't connect to MySQL server on 'localhost'
- Can't connect to MySQL server on 'localhost' (10048)
- Can't connect to MySQL server on 'localhost' (10055)
- #2003: Can't connect to MySQL server on 'localhost' (10061)
- Can't connect to MySQL server on 'localhost' (10061)问题解决
- 解决Can't connect to MySQL server on 'localhost' (10048)
- Can't connect to MySQL server on '' (10060)
- Can't connect to MySQL server on 'localhost' (10061)解决方法
- Can't connect to MySQL server on 'localhost' 解决
- Error: Can't connect to MySQL server on 'localhost' (10061)
- 解决Can't connect to MySQL server on 'localhost' (10048)
- Can't connect to MySQL server on 'localhost'
- Can't connect to MySQL server on 'ip' (13)
- SQL注入漏洞及防止方法
- 有用的英文网站
- 16款创建CSS3动画的jQuery插件
- Win Socket-Raw
- MyBatis入门示例——MyBatis学习笔记之一
- Can't connect to MySQL server on (99) 解法
- IOS团队开发,开发者账号
- 模拟赛 银河之星(即BZOJ 2719: [Violet 4]银河之星)
- Makefile预定义变量的含义
- Ubuntu 14.04下时间同步的设置
- c++中局部变量未初始化引发的离奇惨案~~
- socket心得,转载
- oracle无法通过ip地址连接
- scikit-learn机器学习库介绍(翻译tutorial)