Solution For Too Many Connections Error MySQL Problem

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.

• Status: Open
• Question Views: 366
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: OS
• Question Tags: connections | error MySQL

Answered By Lillian Garsia 0 points N/A #300572

Solution For Too Many Connections Error MySQL Problem

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.

About Lillian Garsia

Questions
19

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/09/2017
• Question Category: OS