Too Many Connections in phpMyAdmin and Sites Offline

[PostAlmostAnything]

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?

 

[kodeslogic]

The following URL will help you to troubleshoot this issue further:

https://support.cpanel.net/hc/en-us/articles/360053530613--mysqli-connect-Too-many-connections

 

[HostNoc]

Hi

Can you please share the result of following Query

SHOW VARIABLES LIKE 'max_connections';

Regards
SAM

 

[cPRex]

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:

mysqladmin proc status

That will show you any active queries, and if any specific databases are having issues.

 

[PostAlmostAnything]

I increased the max connections and that seems to have done the trick.

 

[kodeslogic]

Glad you have it resolved.