Too connector connections in MySQL

Solution to the too connector connections problem in MySQL
Keyword: MySQL
When using MySQL, the too connector connections error is often reported. If you cannot log on, you can only restart the instance. You can solve this problem by using the following methods:

1. First modify the/etc/My. CNF file and add the following line

Set-variable = max_connections = 500

Or add the parameter max_connections = 500 to the startup command.
It is to modify the maximum number of connections, and then restart mysql. The default number of connections is 100, which is too small, so the problem is prone to errors.

2. Restart MySQL and run show variables to check whether max_connections has been modified successfully.

3. To prevent logon failures during too connector connections, MySQL Manual provides the following instructions:

Mysqld actually allows max_connections + 1 clients to connect. the extra connection is reserved for use by accounts that have the super privilege. by granting the super privilege to administrators and not to normal users (who shocould not need it ), an administrator can connect to the server and use show processlist to diagnose problems even if the maximum number of unprivileged clients are connected.

therefore, only the super permission of the root user must be granted, and the super permission cannot be granted to all database connection accounts. The preceding error is caused by the root user directly configured by the Program of our application.