Difference between revisions of "MySQL ERROR 1040"

(Created page with "=MySQL error 1040: Too many connections= {{KB|{{ZC}}|{{ZCS 8.8}}|{{ZCS 8.7}}||}} {{WIP}} ==Problem== This specific error can manifest during different circumstances. Below...")
(No difference)

Revision as of 22:39, 26 September 2019

MySQL error 1040: Too many connections

   KB 23877        Last updated on 2019-09-26  




0.00
(0 votes)


Problem

This specific error can manifest during different circumstances. Below are two examples of such occurrences:


$ /opt/zimbra/libexec/zmdbintegrityreport -r -v 
/opt/zimbra/common/bin/mysqlcheck: Got error: 1040: Too many connections when trying to connect 
$ /opt/zimbra/bin/zmmysqlstatus 
ERROR 1040 (HY000): Too many connections 
Error while running 'mysql --user=zimbra --password=******** --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 256.

Resolution

1/ Enter mysql command line: $ mysql

Once inside


Verified Against: Zimbra Collaboration 8.7, 8.8.9, 8.8.12 Date Created: 7/10/2019
Article ID: https://wiki.zimbra.com/index.php?title=MySQL_ERROR_1040 Date Modified: 2019-09-26



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »


Wiki/KB reviewed by SME1 SME2 COPY EDITOR Last edit by Teodor Vizirov
Jump to: navigation, search