To many Connections issue in MYSQL DB for On-Premise Environment in 18.4 version

Question

Hi Team, 
 one of our On-premise Environment got freshly installed with 18.4 version, while using the MYSQL DB we are facing issue as "Too Many Connection". So we have revoked all permission and dropped all users from the DB side, But still we are facing the issue as "Too Many Connection", Max_used_connections and Threads_connected to DB are keep on automatically increasing to the max limit of 151. 
 Any help would be appreciated. 
 
 Regards, 
 Krishna.

Stefan Helzle · Accepted Answer

docs.appian.com/.../Configuring_Relational_Databases.html , see initialSize and maxTotal

thanigaivelr · Answer

Hi Krishna, 
 
Please find the below link for the more information about this issue, 
 dev.mysql.com/.../too-many-connections.html 
 
These following reasons cause MySQL to run out connections. 
1.Slow Queries 
2.Data Storage Techniques 
3.Bad MySQL configuration 
 
I was able to overcome this issues by doing the followings. 
 
Open MySQL command line tool and type, 
 
show variables like "max_connections"; 
 
This will return you something like this. 
| Variable_name | Value | 
| max_connections | 100 | 
 
You can change the setting to e.g. 200 by issuing the following command without having to restart the MySQL server. 
 
set global max_connections = 200;