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. It's 100% free, no registration required.

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 setting up a new mysql server as we're building a new app at work. Most of the developers/operations guys are familiar with mysql.

Many of mysql's settings (eg strict mode) are set badly by default for backwards compatibility.

Is there a widely accepted list of which settings have defaults that are dangerous, confusing or otherwise wrong?

I'd like to avoid things like the string 'hello' being considered equal to the integer zero, for instance.

share|improve this question

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.