How to set max connections in mysql?
First we want to enter into the Mysql command line prompt by giving the Password MySQL> Enter the password : xxxxxxx To know how many connections are in the database MySQL> show variables like "max_connections"; It will list out the output as Variable Name Value max_connections 100 Default value for the max_connections is 100. If we want to increase the max connections then we wan to give Set global max_connections = "our value" [our value refers= 200,300,500 etc...] It will affect immediately. and it will again remain to max_connections as 100 when the mysql server restarts. For that we want to change the My.conf[for linux OS] or My.ini file [for windows OS] Thanks for viewing our post..