How to use mysqldiff in a mixed SSL environment

[Roy Paterson]

I'm trying to use the mysqldiff utility to compare databases on two different servers. One server is hosted at Amazon (RDS), and the other server I'm running locally. To connect to the Amazon server I have to specify --ssl-ca <file>. My local server doesn't have SSL set up so I *can't* specify this option.

This puts me between a rock and a hard place - either mysqldiff will connect to one server or the other, but not both.

If I don't specify --ssl-ca then the mysqldiff errors for the RDS server: Access Denied.

If I do specify --ssl-ca then mysqldiff errors for my local server: ERROR: Lost connection to MySQL server at 'localhost:3306', system error: 1 _ssl.c:504: error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number

Note I can successfully diff two databases running locally (without --ssl-ca) or two databases running on RDS (with --ssl-ca), so I'm confident I'm using mysqldiff correctly.

Is there any way around this problem?

Thanks,
Roy