我现在做了一个小程序来测试远程连接服务器的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();
}*/
}希望大家看看是哪里问题 总是访问错误~~
账户什么的安全都已经设置好,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();
}*/
}希望大家看看是哪里问题 总是访问错误~~
http://www.connectionstrings.com/mysql#p28
String mysqlStr = "Database=BjxSp;Data Source=210.83.230.182;User Id=bjxsp;Password=1234;pooling=false;CharSet=utf-8;port=3306"; MySqlConnection mysql = new MySqlConnection(mysqlStr);
mysql.Open();
这样还是不能访问,真不知道是哪里问题了哦,这样做到底正确不恩??还是外网根本不能访问我服务器的数据库呢 服务器是linux的
{
//MessageBox.Show("数据库连接失败,友情提示");
throw;
}
有异常就要华丽丽地抛出来然后在看看异常是怎么说的把异常仍到google里面 搜搜看 看看别人是怎么解决的
Uanble to connect to any of the specified MySQL hosts.
上面是异常抛出的 大家帮忙分析下啊