CentOS MySQL 配置二进制日志

CentOS MySQL 配置二进制日志

1.开启服务并登陆MYSQL

[ root@bogon] # service mysql start

[ root@bogon] #{path}/bin/mysql -uroot -p

2.查看当前是否已开启二进制文件

mysql -> show variables like 'log_%';

“Variable_name” “Value”
“log_bin” “ON”
“log_bin_basename” “/program/mysql/data/bogon-bin”
“log_bin_index” “/program/mysql/data/bogon-bin.index”
“log_bin_trust_function_creators” “OFF”
“log_bin_use_v1_row_events” “OFF”
“log_builtin_as_identified_by_password” “OFF”
“log_error” “/program/mysql/data/bogon.err”
“log_error_verbosity” “3”
“log_output” “FILE”
“log_queries_not_using_in