ERROR 1040 (HY000): Too many connections MySQL

Following error occurs when connection limit reaches the maximum limit as defined in the configuration file. The variables holding this value is max_connections. If you want connect MySQL server either kill some of existing connections or login as root and then increase the max_connections limits.

ERROR 1040 (HY000): Too many connections

To check the current value of this variable, login as root user and run the following command:

show variables like “max_connections”;

mysql> show variables like “max_connections”;

Output

+-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+

Solution for ERROR 1040 (HY000): Too many connections
So, number of connection allowed to this MySQL server is 151. If you want connect MySQL server either kill some of existing connections or increase the max_connections limits.

Login to MySQL using root user and increase the max_connections variable to higher value.

SET GLOBAL max_connections = 200;

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools