usingMySql.Data.MySqlClient;usingRenci.SshNet;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespaceSSHMySql
{public partial classForm1 : Form
{publicForm1()
{
InitializeComponent();
SSHConnectMySql();
}public voidSSHConnectMySql()
{string SSHHost = "*.*.*.*"; //SSH地址
int SSHPort = 22; //SSH端口
string SSHUser = "user"; //SSH用户名
string SSHPassword = "pwd"; //SSH密码
string sqlIPA = "127.0.0.1";//映射地址 实际上也可以写其它的 Linux上的MySql的my.cnf bind-address 可以设成0.0.0.0 或者不设置
string sqlHost = "192.168.1.20"; //mysql安装的机器IP 也可以是内网IP 比如:192.168.1.20
uint sqlport = 3306; //数据库端口及映射端口
string sqlConn = "Database=mysql;Data Source=" + sqlIPA + ";Port=" + sqlport + ";User Id=user;Password=pwd;CharSet=utf8";string sqlSELECT = "select * from user";
PasswordConnectionInfo connectionInfo= newPasswordConnectionInfo(SSHHost, SSHPort, SSHUser, SSHPassword);
connectionInfo.Timeout= TimeSpan.FromSeconds(30);using (var client = newSshClient(connectionInfo))
{try{
client.Connect();if (!client.IsConnected)
{
MessageBox.Show("SSH connect failed");
}var portFwdL = new ForwardedPortLocal(sqlIPA, sqlport, sqlHost, sqlport); //映射到本地端口
client.AddForwardedPort(portFwdL);
portFwdL.Start();if (!client.IsConnected)
{
MessageBox.Show("port forwarding failed");
}
MySqlConnection conn= newMySqlConnection(sqlConn);
MySqlDataAdapter myDataAdapter= newMySqlDataAdapter();
myDataAdapter.SelectCommand= newMySqlCommand(sqlSELECT, conn);try{
conn.Open();
DataSet ds= newDataSet();
myDataAdapter.Fill(ds);
dataGridView1.DataSource= ds.Tables[0];
}catch(Exception ee)
{
MessageBox.Show(ee.Message);
}finally{
conn.Close();
}
client.Disconnect();
}catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}