Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm running a Linux (512MB of RAM) server with MySQL 5.1.

I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would fail if more than one user connected. I checked the log files and it showed there were too many connections.

So, I then checked my.cnf and I see the following:


# Disabling symbolic-links is recommended to prevent assorted security risks


I haven't opened up my.cnf since I installed MySQL over 4 months ago.

1) Why in the world would max_user_connections and max_connections randomly get set to 1?

2) Next question is, what should I set those two values to?

3) Should I be worried that this random change will happen again?

* NOTE: I noticed this started after I changed some things in my SSH config file to allow for a more secure public/private key connection while using SFTP. Could that have really made a difference in the MySQL Config?

Thanks for any help you can provide!

share|improve this question
Does the timestamp on the my.cnf file show it was modified? – Phil Mar 15 '13 at 14:14
@Phil: Stupid me, I'm not sure... I edited my.cnf already, before checking the timestamp... DARN!! – FastTrack Mar 15 '13 at 14:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.