首页 > 数据库 >MySQL Data source rejected establishment of connection, message from server: “Too many connections“

MySQL Data source rejected establishment of connection, message from server: “Too many connections“

时间:2022-12-23 14:33:28浏览次数:45  
标签:MySQL 连接数 server connections source rejected mysql Data Too


MySQL数据库中Data source rejected establishment of connection "Too many connections"异常解决

错误原因:

 利用C3P0数据源,连接MySQL服务器时,产生了太多的连接数,数据库客户端连接用户过多,而配置的mysql连接数过小,或者某些连接没有关闭,导致连接数过大。

解决办法:

我的mysql是在windows上安装的,解决办法如下:

找到自己的mysql安装目录中的my.ini配置文件,以记事本方式打开。

MySQL Data source rejected establishment of connection, message from server: “Too many connections“_连接数

在该文件中,添加如下配置信息:

MySQL Data source rejected establishment of connection, message from server: “Too many connections“_mysql_02

max_connections=500
max_user_connections=500
wait_timeout=200

然后重启项目即可。

标签:MySQL,连接数,server,connections,source,rejected,mysql,Data,Too
From: https://blog.51cto.com/u_7044146/5965627

相关文章