Skip to content

Instantly share code, notes, and snippets.

@toshi0383
Created January 3, 2014 10:46
Show Gist options
  • Save toshi0383/8236060 to your computer and use it in GitHub Desktop.
Save toshi0383/8236060 to your computer and use it in GitHub Desktop.
MacOSXでMySQLの設定をUTF8(日本語insert可)にする ref: http://qiita.com/toshi0383/items/ea3996b4c499084df01d
/usr/local/mysql/my.cnf
mysql> show variables like '%dir';
+---------------------------+--------------------------------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------------------------------+
| basedir | /usr/local/mysql |
| character_sets_dir | /usr/local/mysql-5.6.15-osx10.7-x86_64/share/charsets/ |
| datadir | /usr/local/mysql/data/ |
| innodb_data_home_dir | |
| innodb_log_group_home_dir | ./ |
| lc_messages_dir | /usr/local/mysql-5.6.15-osx10.7-x86_64/share/ |
| plugin_dir | /usr/local/mysql/lib/plugin/ |
| slave_load_tmpdir | /var/tmp/ |
| tmpdir | /var/tmp/ |
+---------------------------+--------------------------------------------------------+
9 rows in set (0.00 sec)
$ mysql --help | grep my.cnf
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment