How to fix MySQL Too Many Connections error

1- Open your MySql client, e.g. SQLyog.

2- Run the following command to see how  many concurrent connections is MySql server currently allowing:
SHOW VARIABLES LIKE "max_connections";

3- Run the following command to increase the number of concurrent connections:
SET GLOBAL max_connections = 1000;

 

Check MySQl official page for more details.

 

 

 

 .

Advertisements

One thought on “How to fix MySQL Too Many Connections error

Leave your comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s