c ssh连接mysql数据库连接_C#通过SSH连接MySql

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);

}

}

}

}

}