Windows MySQL 5.7.19 open bin-log and MySQL configuration

First, configure the environment:

Os:win10

mysql:5.7.19

Second, my MySQL configuration file (My.ini) is as follows:

[Client]port=3306default-character-set=utf8[mysqld] #Path to install software directory Basedir=e:\mysql-5.7.19#path To the database Directorydatadir=g:\mysql_data#port numberport=3306#created and no character set is Definedcharacter_set _server=utf8#set the SQL mode to strictsql_mode= "No_engine_substitution,no_auto_create_user,strict_trans_tables" explicit_defaults_for_timestamp=true# Binary logginglog-bin=mysql-binbinlog-format=row#the default storage engine That'll be used when create new tables Whendefault-storage-engine=innodb#general and Slow logginglog-output=filegeneral -log=0general_log_file= "Yuri.log" slow-query-log=1slow_query_log_file= "Yuri-slow.log" Long_query_time=10#error Logginglog-error= "Yuri.err" #Server idserver-id=201609

Note:

in MySQL 5.7.3 and later versions, if Server-id is not set, the MySQL service cannot be turned on after setting Binlog. (Bug #11763963, bug #56739)

Another way to configure:

#log_bin =on#log_bin_basename=g:\mysql_data\mysql-bin#log_bin_index=g:\mysql_data\mysql-bin.index

But the default is the above.

Three parameter meanings:

The first parameter is to open the Binlog log

The second parameter is the base file name of the Binlog log, followed by an identity appended to represent each file

The third parameter specifies the index file for the Binlog file, which manages the directory of all the Binlog files.

Third, start the MySQL test and check whether it looks successful, if you can see the boot success

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/03/C6/wKiom1mf38KyBleuAABfrYgWKwg819.jpg-wh_500x0-wm_ 3-wmp_4-s_3322542542.jpg "title=" binlog.jpg "alt=" Wkiom1mf38kybleuaabfrygwkwg819.jpg-wh_50 "/>

This article is from the "Old White blog" blog, please be sure to keep this source http://laobaiv1.blog.51cto.com/2893832/1959360

MySQL 5.7.19 on bin-log and MySQL configuration under Windows