長島冰茶的工程師筆記

$ mysql -u root -p -e 'SHOW VARIABLES WHERE Variable_Name LIKE "%dir"'
Enter password:
+---------------------------+--------------------------------------------------------+
| Variable_name             | Value                                                  |
+---------------------------+--------------------------------------------------------+
| aria_sync_log_dir         | NEWFILE                                                |
| basedir                   | /usr/local/Cellar/mariadb/10.1.9                       |
| character_sets_dir        | /usr/local/Cellar/mariadb/10.1.9/share/mysql/charsets/ |
| datadir                   | /usr/local/var/mysql/                                  |
| innodb_data_home_dir      |                                                        |
| innodb_log_arch_dir       | ./                                                     |
| innodb_log_group_home_dir | ./                                                     |
| lc_messages_dir           |                                                        |
| plugin_dir                | /usr/local/Cellar/mariadb/10.1.9/lib/plugin/           |
| slave_load_tmpdir         | /var/tmp/                                              |
| tmpdir                    | /var/tmp/                                              |
| wsrep_data_home_dir       | /usr/local/var/mysql/                                  |
+---------------------------+--------------------------------------------------------+