Too Many Connections in phpMyAdmin and Sites Offline

PostAlmostAnything

Well-Known Member
Mar 3, 2020
70
1
8
Portland, Oregon
cPanel Access Level
Website Owner
I have been having a problem the past 24 hours. My sites display errors that they cannot connect to the database and when I try to use phpMyAdmin I get mysqli_real_connect(): (08004/1040): Too many connections

I tried setting the max_connections to 300 because my research indicates that exceeds the default.

How do I fix this?
 
Last edited by a moderator:

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
515
242
118
IN
cPanel Access Level
Root Administrator
  • Like
Reactions: cPRex

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,497
1,967
363
cPanel Access Level
Root Administrator
Whenever I run into any type of MySQL issue, the first thing I do is check and see what MySQL is actually doing in real-time with this command:

Code:
mysqladmin proc status
That will show you any active queries, and if any specific databases are having issues.
 

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
515
242
118
IN
cPanel Access Level
Root Administrator
Glad you have it resolved.