2 ways to modify the maximum number of MySQL connections

MySQL default maximum connection number is 100, add the default MySQL connection number method has two

Method One: Enter the MySQL installation directory to open the MySQL profile my.ini (Windows) or MY.CNF (Linux environment) lookup max_connections=100 Modify to max_connections=1000 Re-start MySQL in the service

Method Two:

Client Login: mysql-u username-p password

Set the new maximum number of connections to 200:mysql> set GLOBAL max_connections=200

Displays the currently running query:mysql> show processlist

Show current status:mysql> show status

Exit Client:mysql> Exit

View current maximum number of connections: mysqladmin-u username-p Password variables