max_connections in mysql

Dshah · 12-20-2009, 09:56 AM

hi i have centos vps whch i am connecting through putty from my local windows 7, mostly things were installed by my provider, now the problem is some of my website pages give me error sometime cant connect to database, my provider told me to increase max_connections in mysql setting maybe it could help, i don't know where to look that file, i did this # nano /etc/my.cnf and i saw the file has only two lines as below:

[mysqld]
local-infile=0

please any help how can i change maz_connections. i am very new to this all.

Thanks for the support

TB0ne · 12-20-2009, 10:22 AM

Quote:

Originally Posted by Dshah

hi i have centos vps whch i am connecting through putty from my local windows 7, mostly things were installed by my provider, now the problem is some of my website pages give me error sometime cant connect to database, my provider told me to increase max_connections in mysql setting maybe it could help, i don't know where to look that file, i did this # nano /etc/my.cnf and i saw the file has only two lines as below:

[mysqld]
local-infile=0

please any help how can i change maz_connections. i am very new to this all.

Well documented on the MySQL site, Google leads you to it:
http://dev.mysql.com/doc/refman/5.1/...nnections.html