title: MAMP MySQL not recognizing my.cnf values in OSX
body: <p>Trying to go UTF8 permanently and can't get MAMP's install of MySQL to recognize my.cnf values.</p>
  
  <p>MAMP
  Version 2.0.5 (2.0.5)</p>
  
  <p>MySQL 5.5.9</p>
  
  <p>my.cnf file:</p>
  
  <pre><code>[client]
  default-character-set=utf8
  
  [mysql]
  default-character-set=utf8
  
  [mysqld]
  default-character-set=utf8
  default-collation=utf8_general_ci
  collation_server=utf8_general_ci
  character_set_server=utf8
  init-connect='SET NAMES utf8'
  </code></pre>
  
  <p>Location of file:</p>
  
  <p>/Applications/MAMP/Library/Conf/</p>
  
  <p>MySQL varibles on startup:</p>
  
  <pre><code>mysql&gt; show variables where variable_name LIKE '%char%' OR variable_name LIKE '%colla%';
  +--------------------------+--------------------------------------------+
  | Variable_name            | Value                                      |
  +--------------------------+--------------------------------------------+
  | character_set_client     | utf8                                       |
  | character_set_connection | utf8                                       |
  | character_set_database   | latin1                                     |
  | character_set_filesystem | binary                                     |
  | character_set_results    | utf8                                       |
  | character_set_server     | latin1                                     |
  | character_set_system     | utf8                                       |
  | character_sets_dir       | /Applications/MAMP/Library/share/charsets/ |
  | collation_connection     | utf8_general_ci                            |
  | collation_database       | latin1_swedish_ci                          |
  | collation_server         | latin1_swedish_ci                          |
  +--------------------------+--------------------------------------------+
  </code></pre>
  
  <p>Switching between various db's will get both <code>_database</code> values to utf8, but I can't seem to get both <code>_server</code> options to reflect utf8 / utf8_unicode_ci:</p>
  
  <pre><code>use tsdb;
  
  +--------------------------+--------------------------------------------+
  | Variable_name            | Value                                      |
  +--------------------------+--------------------------------------------+
  | character_set_client     | utf8                                       |
  | character_set_connection | utf8                                       |
  | character_set_database   | utf8                                       |
  | character_set_filesystem | binary                                     |
  | character_set_results    | utf8                                       |
  | character_set_server     | latin1                                     |
  | character_set_system     | utf8                                       |
  | character_sets_dir       | /Applications/MAMP/Library/share/charsets/ |
  | collation_connection     | utf8_general_ci                            |
  | collation_database       | utf8_general_ci                            |
  | collation_server         | latin1_swedish_ci                          |
  +--------------------------+--------------------------------------------+
  </code></pre>
  
  <p>Tried</p>
  
  <pre><code>set global character_set_server = utf8;
  </code></pre>
  
  <p>etc, but it didn't take on restart.</p>
  
  <p>This is my first time messing with my.cnf so I'm sure I'm overlooking something basic. Is there info missing from my.cnf, is the syntax wrong? Or is order important?</p>
  
  <p>Thanks.</p>