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

Running MAMP (not PRO) 2.0.5, MySQL 5.5.9, locally on OS X and I cannot get MySQL to read a my.cnf file.

I've tried throwing it in the following directories with no results:

/Applications/MAMP/conf /Applications/MAMP/Library /Applications/MAMP/db/mysql

On each attempt, I make sure to shutdown the server, move the file and server is then restarted, after which a quick check of SHOW VARIABLES reveals no effect.

I'm using MAMPs my-small.cnf, renaming as my.cnf before copying over.

Any ideas as to what's going on?

share|improve this question
up vote 1 down vote accepted

Added skip-character-set-client-handshake to the [mysqld] group of the my.cnf file.

# The MySQL server

My-small.cnf as supplied in "support files" does not contain this, subsequently my connection was overriding the values, causing me to think the file was not being read... newbie mistake.

Solution mentioned on the MySQL manual here.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.