How to increase max allowed connections in PHPMyAdmin Print

  • 0

1. Check the default max connections

Log into MySQL command line tool and run the following command to get the current default max connections supported by your database server.

mysql> show variables like "max_connections";


2. Increase Max Connections

There are two ways to increase MySQL connections. Here’s the command to update max connections to 200 via MySQL command line tool without restart.

mysql> set global max_connections = 200;

The max you can set this variable too is 10000

Was this answer helpful?

« Back