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
Database Connection Error
-
mikewaterford
- Observer

- Posts: 17
- Joined: Tue Sep 26, 2017 7:52 pm
- Station model: Davis Vantage Vue
- Software: weather Display
- Fraggboy
- Forecaster

- Posts: 193
- Joined: Wed Sep 27, 2017 2:45 pm
- Location: Sunny California
- Station model: Bloomsky II + Storm
- Software: Bloomsky
- Contact:
Re: Database Connection Error
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
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
-
mikewaterford
- Observer

- Posts: 17
- Joined: Tue Sep 26, 2017 7:52 pm
- Station model: Davis Vantage Vue
- Software: weather Display
Re: Database Connection Error
Thanks for the info, i sent the relevant information to my host