MySQL Maximum connections setting

When using the MySQL database, you often encounter a problem that is "Can not connect to MySQL server." Too many connections "-mysql 1040 error because the number of connections that have not yet been released to MySQL has reached the maximum MySQL limit. Typically, the maximum number of connections to MySQL is 100 by default, up to 16384.

There are two ways to modify the maximum number of connections that are commonly used under Windows.

First: command-line modification.

>mysql-uuser-ppassword (command line login MySQL)

Mysql>show variables like ' max_connections ';(look at the maximum number of connections currently available)

Msyql>set global max_connections=1000; (set the maximum number of connections to 1000 to see if the setting is successful again)

Mysql>exit (launched)

The problem with this approach is that the maximum number of connections set is only valid in the MySQL current service process and will revert to its original state once MySQL restarts. Because the initialization after MySQL starts is to read the data from its configuration file, this method does not make changes to its configuration file.

MySQL Maximum connections setting