Page 1 of 1

Database Connection Error

Posted: Mon Mar 05, 2018 10:27 am
by mikewaterford
I currently have no connection to the database and am getting this error

Error: Unable to connect to MySQL.
Debugging error number: 1040
Debugging error: Too many connections

I have had this problem before and a reset of the database fixes the issue but i have to contact the host every time it happens which can be a pain.
Has anyone else had this issue and if so how was it resolved??

Regards

Re: Database Connection Error

Posted: Mon Mar 05, 2018 7:12 pm
by Fraggboy
The default number of connections is 151. You need to have your hosting company add (Or yourself) this variable: max_connections+1


mysqld actually permits max_connections+1 clients to connect. The extra connection is reserved for use by accounts that have the SUPER privilege. By granting the SUPER privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of unprivileged clients are connected.

Source: https://dev.mysql.com/doc/refman/5.5/en ... tions.html

Re: Database Connection Error

Posted: Tue Mar 06, 2018 7:57 pm
by mikewaterford
Thanks for the info, i sent the relevant information to my host