MySQL installed in MAC M1, enable binlog

mac M1 Next use homebrew Installed mysql, But I can't find my.cnf, This leads to a lot of mysql Can only be set in session In effect ( such as show variables Set the variables listed by the command ),mysql After disconnection and reconnection, it returns to its initial state . You can only modify it if you want to keep it in effect my.cnf.

Use command mysql --verbose --help | grep my.cnf, Can find mysql load my.cnf The default path for , We can check the listed paths in turn .

If none of them exist , We can choose any path to create one , And then restart mysql that will do .

stay my.cnf Add the following configuration to the file :

[mysqld]
# log_bin
log-bin = mysql-bin # Turn on binlog
binlog-format = ROW # choice row Pattern 
server_id = 1       # To configure mysql replication Need to define , Unable to join canal Of slaveId repeat 

Start the service :

brew services start [email protected]
brew services restart [email protected] # restart 
brew services stop [email protected]    # stop it 

perform , Check to see if it is turned on successfully

show variables like 'log_bin';