MySQL Too many connections problem

My process steps:

First step: Determine if your service can be restarted for the first time, if it is possible to restart the second step, if you can not restart the third step, the main consideration has been deployed to the customer site or the database is in use cannot be restarted.

The second step: Find the installation path of MySQL, here to install the system if it is a Linux system, you can use the command where is MySQL. If the Windows system tried the online approach, using the SQL statement: SELECT @ @basedir from dual, but in the MySQL too many state is unable to execute SQL, so this method is not feasible. I have not found a good way, I was found through the default installation path and search, the general installation path is C:\Program files\mysql\mysql Server 5.5. After finding the path to change the configuration file, here are two types of files found in the root directory My.ini file modification inside max_connections = Wait_timeout = 5

The second is to modify the contents of the my.conf file below and then restart the service, open the Task Manager service name for the MySQL stop service, and then restart the service

The restart method has been modified.

The third step: in principle there is no restart can be resolved, unless you turn off a connecting client service. Here I also briefly say, close a client request (for example, the program being requested), make a connection so that you can go through the command mysql-h localhost-uroot-p into MySQL by command show Processlist to find a process ID through the command The Kill Id;id represents the ID number. The personal attempt is to restart the service modification configuration file, if there is no need to restart the way to solve the master explanation.

MySQL Too many connections problem