stringstr="server=127.0.0.1;port=3306;user=root;password=;database=new_schema;";//stringstr="database=new_schema;Password=;UserID=root;server=localhost";//DataSource=MySQ...
string str = "server=127.0.0.1;port=3306;user=root;password= ;database=new_schema;"; //string str = "database=new_schema;Password= ;User ID=root;server=localhost";//Data Source=MySQL;;charset=utf8"; MySqlConnection con = new MySqlConnection(str); con.Open(); string strcmd = "select * from mydb"; MySqlCommand cmd = new MySqlCommand(strcmd, con); MySqlDataAdapter ada = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); ada.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; con.Close();``` 这个是找别人的代码写的,server=127.0.0.1和server=localhost都试过了都连接不上 password写的是六个空格也是没错的 然后就出现图片中的错误 然后我直接用datagridview进行连接就出现如下错误 测试连接成功,但是实际连接不上
展开