Environment Windows7 64-bit
MySQL version: 5.7.17
My.ini configuration:
[client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8# Extract Directory Basedir=d:\ mysql-5.7.15-winx64# extract directory under the data directory Datadir=d:\mysql-5.7.15-winx64\datasql_mode=no_engine_substitution,strict_trans _tables# various logs (query, error, slow query) configuration: #log_bin =d:\mysql-5.7.15-winx64\log\mysql-bin.loglog_error=d:\mysql-5.7.15-winx64\ Log\mysql.errlong_query_time=1slow_query_log=onslow_query_log_file=d:\mysql-5.7.15-winx64\log\ Mysql-slow.loggeneral_log=ongeneral_log_file=d:\mysql-5.7.15-winx64\log\log-mysql.logmax_connections=100table_ Open_cache=256query_cache_size=1mtmp_table_size=32mthread_cache_size=8innodb_flush_log_at_trx_commit=1innodb_ log_buffer_size=128minnodb_buffer_pool_size=128minnodb_log_file_size=10minnodb_thread_concurrency= 16innodb-autoextend-increment=1000join_buffer_size=128msort_buffer_size=32mread_rnd_buffer_size=32mmax_allowed _packet=32mexplicit_defaults_for_timestamp=truesql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_ SUBSTITUTION "#sql_mode =no_engine_substitution,stricT_trans_tables
Restart the MySQL service after Setup is complete.
mysql-5.7 Log Settings