Shulou(Shulou.com)05/31 Report--

Editor to share with you mysql5.7 can not open binary log example analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. The question is as follows: my my.cnf configuration is as follows:

[mysqld]

Datadir=/data/mysql1

Socket=/var/lib/mysql/mysql.sock

Character_set_server=utf8mb4

Symbolic-links=0

Log-error=/data/mysql1/mysqld.log

Pid-file=/data/mysql1/mysqld.pid

Binlog_format=row

Log_bin = binlog

Start mysql: no log is written to the log file, and no error message is reported:

[root@mysql3 data] # mysqld_safe-- defaults-file=/data/my1.cnf

2018-01-08T11:35:55.391941Z mysqld_safe Logging to'/ data/mysql1/mysqld.log'.

2018-01-08T11:35:55.425055Z mysqld_safe Starting mysqld daemon with databases from / data/mysql1

2018-01-08T11:35:55.651401Z mysqld_safe mysqld from pid file / data/mysql1/mysqld.pid ended

Second, analysis: I check the log file / data/mysql1/mysqld.log, there is no log written to / data/mysql1/mysqld.log, there is no other output error information, it is very strange. I repeatedly cross-checked the configuration file and found that the binary log parameters were not written correctly.

Third, the final answer: finally, I found that there is no parameter server_id=1, add this parameter, it will be fine. Binary logs are paired with the parameter server_id.

The above is all the contents of the article "sample Analysis of binary Log cannot be opened by mysql5.7". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.