LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-20-2009, 09:56 AM   #1
Dshah
LQ Newbie
 
Registered: Dec 2009
Posts: 12

Rep: Reputation: 0
max_connections in mysql


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
 
Old 12-20-2009, 10:22 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,788

Rep: Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162Reputation: 4162
Quote:
Originally Posted by Dshah View Post
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 02:21 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 10:32 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM


All times are GMT -5. The time now is 05:09 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration