Sign up ×
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.

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.