How to change the Max connection in MySQL

To change the mysql max connections

open my.cnf and change max_connections to the required number of connections.

For example: To set maximum 300 connections

max_connections = 300

If you don't know where the my.cnf exists in Linux/Unix box, use find command.

find / -name my.cnf