MySQL View and modify the maximum number of connections

Typically, the maximum number of connections to MySQL is 100 by default, up to 16384.
1. View the maximum number of connections:
Show variables like '%max_connections% ';
2. Modify the maximum number of connections
Method One: Modify the configuration file
Vim/etc/my.cnf
Go to the MySQL installation directory to open the MySQL profile My.ini or my.cnf find max_connections=100 modify it for the max_connections=1000 service to restart MySQL.

MySQL View and modify the maximum number of connections