MySQL error 1040: Too many connections
KB 23877
|
Last updated on 2019-09-26
|
Last updated by Teodor Vizirov
|
|
Verified in: ZCS 8.8
ZCS 8.7
|
|
- This is certified documentation and is protected for editing by Zimbra Employees & Moderators only.
|
KB 23877
|
Last updated on 2019-09-26
|
|
|
- This is certified documentation and is protected for editing by Zimbra Employees & Moderators only.
|
- This article is a Work in Progress, and may be unfinished or missing sections.
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
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
|