SSL support for MySQL?

[derekmorr]

Does the plugin support using SSL for MySQL? I haven't seen how to configure it. If it doesn't, it should. I'm trying to use the plugin, but I'm reluctant to send MySQL login credentials and user data in cleartext across a network.

[MegaphoneJon]

You've probably long since solved your issue, but for others: I handled this by using SSH tunnels.
From the old Piwik server, I connected to the new Piwik server with:

ssh username@piwiknew.example.com -L 3307:localhost:3306

I then opened a second SSH session to the old Piwik server, and I could connect to the new Piwik server's MySQL instance on port 3307:

./console migration:site -H 127.0.0.1 --db-prefix=piwik_ --db-port=3307 1

Note that it's important to specify a host of 127.0.0.1 instead of localhost in most cases here, due to how MySQL handles credentials.