Connection to MySQL from .NET using SSH.NET Library

by

Most of the code below is self explanatory. Still I have put the needful comments. I was able to connect to the MySql database with the code below. I had used SSH library from here and MySql connector for .NET.

using(var client = new SshClient("ssh server id", "sshuser", "sshpassword")) // establishing ssh connection to server where MySql is hosted
{
    client.Connect();
    if (client.IsConnected)
    {
        var portForwarded = new ForwardedPortLocal("127.0.0.1", 3306, "127.0.0.1", 3306);
        client.AddForwardedPort(portForwarded);
        portForwarded.Start();
        using (MySqlConnection con = new MySqlConnection("SERVER=127.0.0.1;PORT=3306;UID=someuser;PASSWORD=somepass;DATABASE=Dbname"))
        {
            using (MySqlCommand com = new MySqlCommand("SELECT * FROM cities", con))
            {
                com.CommandType = CommandType.CommandText;
                DataSet ds = new DataSet();
                MySqlDataAdapter da = new MySqlDataAdapter(com);
                da.Fill(ds);
                foreach (DataRow drow in ds.Tables[0].Rows)
                {
                    Console.WriteLine("From MySql: " + drow[1].ToString());
                }
            }
        }
        client.Disconnect();
    }
    else
    {
        Console.WriteLine("Client cannot be reached...");
    }
}

More Related Contents:

  1. How to run commands on SSH server in C#?
  2. Providing input/subcommands to a command (cli) executed with SSH.NET SshClient.RunCommand
  3. Providing subcommands to a command (sudo/su) executed with SSH.NET SshClient.CreateShellStream
  4. Authentication with PPK key in SSH.NET
  5. Error: You have an error in your SQL syntax – but SQL statement works
  6. Quotes in string [closed]
  7. is there a more efficient way to write this sql code?
  8. Parameterized Query for MySQL with C#
  9. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  10. How to connect to MySQL Database?
  11. Configuration System Failed to Initialize
  12. ASP.NET use SqlConnection connect MySQL
  13. Most efficient way to insert Rows into MySQL Database
  14. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  15. Dynamic MySQL database connection for Entity Framework 6
  16. C# with MySQL INSERT parameters
  17. What could be causing a System.TypeLoadException?
  18. Unable to connect to any of the specified mysql hosts. C# MySQL
  19. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  20. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  21. Asking for legitimate example of calling stored procedure C#: MYSQL
  22. Using SqlDataAdapter to insert a row
  23. Get affected rows on ExecuteNonQuery
  24. How to call Stored Procedures with EntityFramework?
  25. How to pass a table as parameter to MySqlCommand?
  26. Testing an Entity Framework database connection
  27. How can I force a log out of all users for a website?
  28. How do I remove emoji characters from a string?
  29. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  30. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0

Leave a Comment