Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql 1040 Too many connections错误

mysql 1040 Too many connections错误

WBOY
Release： 2016-06-07 17:53:09
Original
1190 people have browsed it

本文章来介绍在windows与linux系统下mysql出现这种问题的解决方法，这里主要是只要配置一下max_connections参数即可。


1、Windows系统下的mysql

修改配置文件“my.ini”，中的“max_connections”的值，将值改大即可。

max_connections = 1000

2、Linux系统下的mysql

修改配置文件“my.cnf”中的“max_connections”的值，将值改大即可。
 
max_connections = 1000

重启一下mysql即可应用配置了。

小提示,max_connections在mySQL服务器允许的最大连接数16384哦，如果你是window服务器这里还需要看windows最大性能来配置了。

Related labels：
Too many connections
source：php.cn
Previous article：mysql 日期比较函数 Next article：mysql字符串替换简单介绍
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2189
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2336
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1963
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1848
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1904
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template