【mysql】mac修改mysql5.7配置&开启binlog 博客分类: mysql mysql
程序员文章站
2024-03-20 12:30:22
...
1.mac中安装的mysql默认是没有配置文件的,我们要做的就是
先关闭mysql服务
./support-files/mysql.server stop
然后将support-files文件夹下my-default.cnf内容修改成:
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
保存,然后copy到目录/etc/下面 cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
然后启动mysql
./support-files/mysql.server start
2.开启binlog
在/etc/my.cnf
[mysqld] #log_binlog-bin = mysql-bin #开启binlog binlog-format = ROW #选择row模式 server_id = 1#配置mysql replication需要定义,不能和canal的slaveId重复
重启mysql后binlog开启