Solution For Too Many Connections Error MySQL Problem

Asked By 0 points N/A Posted on -
qa-featured

I have been repeatedly getting the error message saying too many connections error in MySQL. I want to increase the maximum no. of connections. Please tell me how to do that.

SHARE
Answered By 0 points N/A #300572

Solution For Too Many Connections Error MySQL Problem

qa-featured

To increase the maximum number of connections, follow the steps below-

  1. Run MySQL command line show variables like”max_connections”
  2. Then run set global max_connections=’desired value’
  3. To make the change permanent write another line max_connections=’desired value’


This is how you increase the maximum no. of connections permanently.

Related Questions