Method 1: enter the MYSQL installation directory, open the MYSQL configuration file my.ini or my.cnf, find max_connections= 100, modify it to max_connections= 1000, and restart MYSQL in the service.

Method 2: MySQL defaults to a maximum number of connections of 100. Client login: mysql -uusername -ppassword.

Set the new maximum number of connections to 200: MySQL > set globalmax _ connections = 200.

Display the currently running query: MySQL > display the process list.

Show current status: mysql & gt shows status.

Exit client: mysql & gt exit

Check the current maximum number of connections: mysqladmin-uusername-ppassword variable.