MySQL: changing max connection for mysql server

MySQL: changing max connection for mysql server

SHOW variables LIKE "max_connections";

On my client it was:

+-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 151 | +-----------------+-------+

You can change the setting to e.g. 1000 by issuing the following command without having to restart the MySQL server:

SET global max_connections = 1001;

One connection I added for root which mysql reserves. And you should edit your config /etc/mysql/my.cnf and set max_connections = 1001.