ERROR 1040 (HY000) Too many connections

C:\Users\Jilil>mysql -u root -p
Enter password: *************
ERROR 1040 (HY000): Too many connections

C:\Users\Jilil>
C:\Users\Jilil>
java.sql.SQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections"

Solution:
show variables like "max_connections";
set global max_connections = 200;
or if you can't connect:
systemctl daemon-reload
systemctl restart mysql

posted @ 2021-02-24 04:48  Orchidelle  阅读(94)  评论(0编辑  收藏  举报