Re: Connect to MySQL using MySQL Connector.NET and SharpSsh
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 ...");
Subject
Written By
Posted
Re: Connect to MySQL using MySQL Connector.NET and SharpSsh
June 25, 2014 07:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.