Summary of tips for setting the maximum number of connections in MySQL

Method 1: Command line modification

We only need to open the MySQL console and enter the "set GLOBAL max_connections=1000;" statement to directly set the maximum number of connections, as shown in the following figure:

Note: This method is only a temporary solution and can only temporarily modify the maximum number of connections. If you restart MySQL, the maximum number of connections will return to the original setting.

Method 2: Modify the maximum number of connections through the MySQL configuration file

1. Open the MySQL installation directory on the computer and find the my.ini file, as shown in the following figure:

2. Open the my.ini file with Notepad, find and modify the value of "max_connections". The default maximum number of connections is 100, as shown in the following figure:

Set "max_connections=1000" to set the maximum number of MySQL connections to 1000.

3. After setting the maximum number of connections, you need to restart the MySQL service

In [Computer]-->[Management]-->[Services and Applications]-->[Services]-->[MySQL]

Click mysql and right-click to start or shut down, as shown in the following figure:

This sets the maximum number of MySQL connections to 1000, and it is a permanent setting.