c# - 如何形成正确的MySQL连接字符串？

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 9 年前。

Improve this question

我正在使用 C#，并且正在尝试连接到 00webhost 托管的 MySQL 数据库。 .

我在 connection.Open() 线上收到错误:

there is no MySQL host with these parameters.

我已经检查过了，一切似乎都没问题。

string MyConString = "SERVER=mysql7.000webhost.com;" +
            "DATABASE=a455555_test;" +
            "UID=a455555_me;" +
            "PASSWORD=something;";

MySqlConnection connection = new MySqlConnection(MyConString);

MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;

command.CommandText = "INSERT Test SET lat=" + 
OSGconv.deciLat + ",long=" + OSGconv.deciLon;

connection.Open();
Reader = command.ExecuteReader();

connection.Close();

此连接字符串有什么问题？

Answer 1

尝试以这种方式创建连接字符串:

MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();
conn_string.Server = "mysql7.000webhost.com";
conn_string.UserID = "a455555_test";
conn_string.Password = "a455555_me";
conn_string.Database = "xxxxxxxx";

using (MySqlConnection conn = new MySqlConnection(conn_string.ToString()))
using (MySqlCommand cmd = conn.CreateCommand())
{    //watch out for this SQL injection vulnerability below
     cmd.CommandText = string.Format("INSERT Test (lat, long) VALUES ({0},{1})",
                                    OSGconv.deciLat, OSGconv.deciLon);
     conn.Open();
     cmd.ExecuteNonQuery();
}