1.windows服务下删除mysql服务
sc delete mysql
2.创建mysql用户
create user ‘dong’
3.设置用户权限和基本信息
GRANT REPLICATION SLAVE ON . TO ‘dong’@’192.168.0.%’ IDENTIFIED BY ‘123456’;
4.查看用户信息
select host,user from mysql.user;
5.mysql查看日志
mysqld -console
6.触发器更新其他表数据
update clz_data set market_id = new.id WHERE jcdw = old.market_name