Solution: 1040-Too connector connections Error

When starting a web service today, Tomcat always fails to be started in eclipse. When starting this web service, an error is reported when accessing tables in other MySQL databases, for example:

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4C/C0/wKioL1REzZvxADXBAABUZcLTvxU632.jpg "Title =" 1.png" alt = "wkiol1rezzvxadxbaabuzcltvxu632.jpg"/>

Error cause: the maximum number of connections specified by MySQL is 151, but the 200 connections are initialized in the initiated web service initialization connection pool. Therefore, Tomcat fails to start the service, in addition, when the web service is started, the number of database connections initialized exceeds the number specified by MySQL. As a result, an error is reported when operating the database tables of other applications (1040-too connections)

(The show full processlist command can be used to view the connection status of the current database)

Solution: Modify the maximum number of connections of MySQL.

Database environment: Window 7 + mysql5.7

Modify the maximum number of connections. Modify max_connections = 5.7 in file D: \ programdata \ mysql server 1000 \ My. ini.

Restart MySQL.

This article is from the "bccat technical history" blog, please be sure to keep this source http://bccat.blog.51cto.com/8845284/1565963

Solution: 1040-Too connector connections Error