1.docker安装mysql: docker pull mysql:latest
2.docker启动mysql: docker run -itd —name mysql01 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql
3.docker安装之后进入mysql:docker exec -it mysql01 bash
注意点1:启动mysql客户端必须先进入mysql,然后执行 mysql -uroot -p
4.问题:mysql 使用navicat连接出错?https://blog.csdn.net/weixin_43187491/article/details/88677034
5.mysql最新版是默认开启binlog的,意味着,数据发生改变,canal就能够监听到!
6.配置canal监听:
授权 canal 链接 MySQL 账号具有作为 MySQL slave 的权限, 如果已有账户可直接 grant:
create user canal@’%’ IDENTIFIED by ‘canal’;
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT,SUPER ON . TO ‘canal’@’%’;
FLUSH PRIVILEGES;
7.涉及mysql配置操作,要重启才可生效—-》重启命令:docker restart mysql01
8.docker mysql 修改mysql相关的配置文件:https://www.cnblogs.com/boboblue/p/12161482.html
- Errorstarting userland proxy: listen tcp4 0.0.0.0:3306: bind: address already in use:https://blog.csdn.net/weixin_42236165/article/details/92121106