[client] no-beep port=3306 [mysql] default-character-set=utf8 [mysqld] port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.6/" datadir="C:/ProgramData/MySQL/MySQL Server 5.6-1/data/" character-set-server=utf8 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=0 table_open_cache=2000 tmp_table_size=33M thread_cache_size=8 myisam_max_sort_file_size=100G myisam_sort_buffer_size=125M key_buffer_size=55M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=64M innodb_buffer_pool_size=512M innodb_log_file_size=512M innodb_thread_concurrency=16 innodb_file_per_table=1 innodb_file_format=Barracuda innodb_checksum_algorithm=0 log-output=FILE general-log=0 general_log_file="general.log" slow-query-log=1 slow_query_log_file="slow.log" long_query_time=3 server-id=10 auto_increment_increment=2 auto_increment_offset=1 log-bin=bin-log binlog-format=ROW max_binlog_size=1G log-slave-updates relay-log=relay-log sync_binlog=1 expire_logs_days=1 performance_schema=0 max_allowed_packet=70M metadata_locks_hash_instances=256 relay_log_info_repository = TABLE relay_log_recovery = ON