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

This article mainly introduces how to use mysqlbinglog, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Encountered a problem when using mysqlbinlog to view the log

The error message is as follows:

/ usr/local/mysql/bin/mysqlbinlog: unknown variable 'default-character-set=utf8'

The reason for this problem is that I added to the client option group in my.cnf

Default-character-set=utf8

The solution to the problem:

NO.1 uses:-- no-defaults

. / mysqlbinlog-- no-defaults mysql-bin.000063

NO.2 comments out the configuration file my.cnf under [client]

Default-character-set=utf8 option

NO.3 modifies the configuration file under [client] in my.cnf

The default-character-set=utf8 of

Thank you for reading this article carefully. I hope the article "how to use mysqlbinglog" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.