database - How to increase MySQL connections(max_connections)? -

every socket of mysql database have defaults connections 100 looking way increase number of possible connections > 100 socket connection of mysql database.

if need increase mysql connections without mysql restart below

mysql> show variables 'max_connections'; +-----------------+-------+ | variable_name   | value | +-----------------+-------+ | max_connections | 100   | +-----------------+-------+ 1 row in set (0.00 sec)  mysql> set global max_connections = 150; query ok, 0 rows affected (0.00 sec)  mysql> show variables 'max_connections'; +-----------------+-------+ | variable_name   | value | +-----------------+-------+ | max_connections | 150   | +-----------------+-------+ 1 row in set (0.00 sec) 

these settings change @ mysql restart.

---

for permanent changes add below line in my.cnf , restart mysql

max_connections = 150