How to fix MySQL Too Many Connections error

Posted on by

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:

Gravatar
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
Cancel

Connecting to %s