# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[client]
compress
port = 3306
socket = \\socket\\mysql

[safe_mysqld]
socket = \\socket\\mysql
nice = 0

[mysqld]
user = mysql
skip-external-locking
pid_file = C:/var/run/mysql/mysql.pid
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 16M
#table_open_cache = 64
#sort_buffer_size = 512K
#read_buffer_size = 256K
#read_rnd_buffer_size = 512K
#net_buffer_length = 8K
#myisam_sort_buffer_size = 8M
wait_timeout = 60
innodb_flush_neighbors=0
log_error = C:/var/log/mysql/error.log
expire_logs_days=10
max_binlog_size = 100M
secure_file_priv = C:/var/lib/mysql
lower_case_table_names = 2
explicit_defaults_for_timestamp

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 256M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = C:/Programs/mysql56
datadir = C:/Data/mysql5
tmpdir = C:/var/tmp
port = 3306
server_id = 1
socket = \\socket\\mysql
bind-address = 127.0.0.1


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqldump] 
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash

[isamchk]
key_buffer_size = 16M
#sort_buffer_size = 16M
#read_buffer = 2M
#write_buffer = 2M

[mysqlhotcopy]
#interactive-timeout