创建用户并授权

delete from mysql.user where user='canal'; 
# 创建用户canal, 密码为canal123  
# 如果你开启了主从的话，mysql8的话，最好用上WITH mysql_native_password参数，否则可能导致主从复制开启失败
create user 'canal'@'%' identified WITH mysql_native_password by 'canal123';
create user 'canal'@'localhost' identified WITH mysql_native_password  by 'canal123';
# *.* to 'canal'@'%',  *.*表示所有库所有表, canal表示用户名, %表示所有ip地址。即:给用户canal授予所有库表的权限，不论其的连接来自哪个ip地址
# WITH GRANT OPTION表示，允许该用户给其它用户授权(P.S. 当然只能授予该用户自身有的权限).
# 赋所有权限
# grant all privileges on *.* to 'canal'@'%' WITH GRANT OPTION;
# grant all privileges on *.* to 'canal'@'localhost' WITH GRANT OPTION;
grant insert,delete,update,select on *.* to 'canal'@'%' WITH GRANT OPTION;
grant insert,delete,update,select on *.* to 'canal'@'localhost' WITH GRANT OPTION;
# 刷新权限信息，使刚才的权限配置生效
flush privileges;
# 简单查看一下
select * from mysql.user ;