在从的数据库上使用Load data from master的权限赋予

mysql> GRANT SUPER,REPLICATION CLIENT,REPLICATION SLAVE,RELOAD ON *.* TO 'repl'@' 172.16.140.108' IDENTIFIED BY 'bbsrep';

添加新评论 »