急啊~~~C#连接Mysql问题~~
我现在做了一个小程序来测试远程连接服务器的Mysql,服务器的系统是linux~~~~
账户什么的安全都已经设置好,linux防火墙也已经关闭,但就是访问不同。往高手指点,
下面是小程序 简单的几句~~
private string ip = "210.83.230.182"; // 需要修改ip在这里
private string databasename = "BjxSp"; //数据库名称
private string username = "bjxsp"; //数据库用户名
private string password = "1234"; //数据库密码
private string tabalename = "SPMark"; //数据库表
//这里是一个按钮事件 WIN form下做的
private void button1_Click(object sender, EventArgs e)
{
MySqlConnection conn = null;
string connStr = "";
try
{
//conn = new MySqlConnection("Database='" + ip + "';Data Source='" + databasename + "';User Id='" + username + "';Password='" + password + "'");
//MessageBox.Show(conn.ToString());
//conn.Open();
/*
MySqlCommand commn = new MySqlCommand("set names utf-8", conn);
commn.ExecuteNonQuery();
string sql = "select * from " + tabalename;
MessageBox.Show(sql);
MySqlDataAdapter mda = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
mda.Fill(ds, "table1");
dataGridView1.DataSource = ds.Tables["table1"];*/
}
catch
{
MessageBox.Show("数据库连接失败,友情提示");
}
/*finally
{
conn.Close();
}*/
}
希望大家看看是哪里问题 总是访问错误~~