Databases
StackOverflow2013
Postsdbo
POMAMP MySQL not recognizing my.cnf values in OSX
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMAMP MySQL not recognizing my.cnf values in OSX
    text
    copied!<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>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload