Home > Database > Mysql Tutorial > mysql出现too many connections错误提示的解决办法_MySQL

mysql出现too many connections错误提示的解决办法_MySQL

WBOY
Release: 2016-06-01 13:43:18
Original
1200 people have browsed it

bitsCN.com 错误提示如:
$mysql -uroot
ERROR 1040 (00000): Too many connections
 
因为我用的是mysql5服务器是win2000这个办法好解决了,找到我mysql安装目录如C:windowsmysql找到my.ini配置文件了。
ctrl+f搜索max_connections,原因找到了,因为你的mysql安装目录下的my.ini中设定的并发连接数太少或者系统繁忙导致连接数被占满,这里不知道什么时间被设计成2了,下面我把它改成
max_connections = 1000
max_user_connections=300
 
最后重启数据库就可以了。
上面讲得是有mysql服务器权限的,如果没有的朋友可以联系空间商哦。


作者 php开发 bitsCN.com

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template