Re: Connect to MySQL using MySQL Connector.NET and SharpSsh

[Shawn Green]

1) Which error from MySQL are you getting. You may simply not be authorized to connect to MySQL from your current machine.

http://dev.mysql.com/doc/refman/5.6/en/connection-access.html

2) I've never used SharpSSH but I do read in its description that it does port forwarding.

If you do forward port 3306 from your remote system (where your mysqld lives) to your local system, then tell your C/NET library to connect to the local copy of that port.

For example, if I forward 10.0.0.111 Port = 3306 to the local port 3223 then your connection string would look like this

sql_connection = new MySqlConnection("server = 127.0.0.1; Port = 3223; ... the rest of your options ...");