mysql

开机自启

配置Binlog

flinkcdc需要用

1 sudo vim /etc/my.cnf
2 写入
server id = 1 
log-bin=mysql-bin 
binlog_format=row 
binlog-do-db=gmall2021
binlog-do-db=gmall2021_realtime
注意：binlog-do-db 根据自己的情况进行修 改，指定具体要同步的数据库，多个就写多行
3 重启mysql
sudo systemctl restart mysqld
4 查看有没有生效
 cd /var/lib
 sudo ls -l mysql | grep bin
 修改mysql库里数据，观察"mysql-bin.最新"文件大小的变化

问题

1 Job for mysqld.service failed because the control process exited with error code

https://blog.csdn.net/qq_41179691/article/details/104598293

2 navicat连不上服务器的mysql

https://blog.csdn.net/u014264373/article/details/85564524

https://blog.csdn.net/MTbaby/article/details/56836986