MySQL 8.0找不到 my.ini 配置文件(并开启 Binlog 监听)

 mysql -u 用户名 -p

 show variables like 'datadir';

# for advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** do not edit this file. it's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of mysql.
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = false
character-set-server = utf8mb4
collation-server = utf8mb4_bin
init_connect='set names utf8mb4'
# remove leading # and set to the amount of ram for the most important data
# cache in mysql. start at 70% of total ram for dedicated server, else 10%.
innodb_buffer_pool_size = 128m
# remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# these are commonly set, remove the # and set as required.
lc-messages-dir = c:\\program files\\mysql\\mysql server 8.0\\share
basedir = c:\\program files\\mysql\\mysql server 8.0
datadir = c:\\program files\\mysql\\mysql server 8.0\\data
port = 3306
# server_id = .....
# remove leading # to set options mainly useful for reporting servers.
# the server defaults are faster for transactions and fast selects.
# adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128m
sort_buffer_size = 16m
read_rnd_buffer_size = 16m 
sql_mode=no_engine_substitution,strict_trans_tables
log-bin=mysql-bin # 开启 binlog
binlog-format=row # 选择 row 模式
server_id=1 # 配置 mysql replaction 需要定义，不要和 canal 的 slaveid 重复

mysqld  --defaults-file="c:\program files\mysql\mysql server 8.0\my.ini"

show variables like 'log_%';