脚本命令
mysqldiff --server1=xxx:"xxx"@192.168.125.223:3306 --server2=xxx:"xxxxx"@192.168.125.223:3306 --difftype=sql onlinexxxx:xxxx.xxxx --changes-for=server2
结果
# WARNING: Using a password on the command line interface can be insecure.
# server1 on 192.168.125.223: ... connected.
# server2 on 192.168.125.223: ... connected.
ERROR: Query failed. 1142 (42000): SELECT command denied to user 'xxxxx'@'192.168.125.16' for table 'proc'
什么鬼！？ 怎么抛出这样的错误？ 挣扎了一晚上，发现换一个NB一点的mysql账号，就解决问题了。