<appSettings>
  <add key="SSHHost" value="79.173.x.y"/>
  <add key="SSHUser" value="xyz"/>
  <add key="SSHPassword" value="xyz"/>
  <add key="SSHPort" value="22"/>
  <add key="SQLHost" value="79.173.x.y"/>
  <add key="SQLIPA" value="127.0.0.1"/>
  <add key="SQLPort" value="1500"/>
  <add key="SQLConnectionString" value="Server=127.0.0.1; Port=3306; Database=test; Uid=xyz; Pass="/>
  <add key="SQLSelect" value="select * from test"/>
</appSettings>

PasswordConnectionInfo connectionInfo = new PasswordConnectionInfo(Const.Host, Const.Port, Const.User, Const.Password);
        connectionInfo.Timeout = TimeSpan.FromSeconds(30);
        using(var client = new SshClient(connectionInfo))
        {
            try
            {
                client.Connect();
                if(client.IsConnected)
                {
                    Console.WriteLine("SSH connection is active");

                } else
                {
                    Console.WriteLine("SSH connection failed");
                }
                var portFwdl = new ForwardedPortLocal(Const.SQLIPA, Const.SQLPort, Const.SQLHost, Const.SQLPort);
                client.AddForwardedPort(portFwdl);
                portFwdl.Start();
                if(portFwdl.IsStarted)
                {
                    Console.WriteLine("PORT forwarding is started");
                } else
                {
                    Console.WriteLine("PORT forwarding faile");
                }
                string strConnection = Const.SQLConn;
                MySqlConnection conn = new MySqlConnection(strConnection);
                string myTablename = "test";
                MySqlDataAdapter myDA = new MySqlDataAdapter();
                myDA.SelectCommand = new MySqlCommand(Const.SQLSELECT, conn);
                MySqlCommandBuilder cb = new MySqlCommandBuilder(myDA);
                try
                {
                    conn.Open();
                    Console.WriteLine("SQL connection is active");
                    DataSet ds = new DataSet("id");
                    myDA.Fill(ds, myTablename);
                    Console.WriteLine(ds.GetXml());
                }
                catch(MySqlException e)
                {
                    Console.WriteLine(e.Message);
                }
                finally
                {
                    conn.Close();
                }
                client.Disconnect();
                Console.WriteLine("SHH Disconnect");

            } catch (SocketException e)
            {
                Console.WriteLine(e.Message);
            }

        }
        Console.ReadKey();

$ mysql -u root -p

> use mysql;
> update user set host='%' where user='plzvtl';
> flush privileges;