We can set the value for global or not global variable as follows: mysql> set global max_connections=300; Query OK, 0 rows affected (0.00 sec) mysql>