mysql5.7.19 log bin_Windows下Mysql 5.7.19 开启bin-log以及mysql配置

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41[client]

port=3306

default-character-set=utf8

[mysqld]

#Path to install software directory

basedir=E:\mysql-5.7.19

#Path to the database directory

datadir=G:\mysql_data

#Port Number

port=3306

#created  and no character set is defined

character_set_server=utf8

#Set the SQL mode to strict

sql_mode="NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLES"

explicit_defaults_for_timestamp=true

# Binary Logging

log-bin=mysql-bin

binlog-format=Row

#The default storage engine that will be used when create new tables when

default-storage-engine=INNODB

#General and Slow logging

log-output=FILE

general-log=0

general_log_file="yuri.log"

slow-query-log=1

slow_query_log_file="yuri-slow.log"

long_query_time=10

#Error Logging

log-error="yuri.err"

#Server ID

server-id=201609