I have installed MySQL for Visual Studio and the .net connector and I have tried this connection string in my app.config:
<add name="mysqlGrowercon" connectionString="Server=*****;Port=3306;Database=GrowerReports;Uid=Developer;Pwd=*****"
And I've tried adding the connection through the Data Source Configuration Wizard but either way I get:
There has been an error, The handshake failed due to an unexpected packet format.
I can connect okay to a SQL Server Amazon RDS just not this MySQL Amazon RDS.
Anyone know what I'm doing wrong?