.my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#
# Include all files from the config directory
#
!includedir /Users/prm/.my.cnf.d

client.cnf

#
# This group is read by the client library. Use it for options that affect all
# clients, but not the server

[client]

server.cnf

#
# This group is read by the server. Use it for options that only affect the
# server.
#

[server]

[mysqld]

# Query cache
query_cache_type            = 1
query_cache_limit           = 2M
query_cache_size            = 64M

# InnoDB
innodb_data_file_path       = ibdata1:1G;ibdata2:512M:autoextend
innodb_autoextend_increment = 512
innodb_log_file_size        = 512M
innodb_buffer_pool_size     = 2G