MySQL: changing max connection for mysql server

Post date: Mar 22, 2011 11:44:32 AM

mysql> 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:

mysql> 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.