Asked By
Chris Leo
0 points
N/A
Posted on - 07/09/2017
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.
Solution For Too Many Connections Error MySQL Problem
To increase the maximum number of connections, follow the steps below-
- Run MySQL command line show variables like”max_connections”
- Then run set global max_connections=’desired value’
- To make the change permanent write another line max_connections=’desired value’
This is how you increase the maximum no. of connections permanently.