mysql通过什么连接字符串_如何形成正确的MySQL连接字符串？

I am using C# and I am trying to connect to the MySQL database hosted by 00webhost.

I am getting error on the line connection.Open():

there is no mysql host with this parameters.

I have checked and everything seems to be fine.

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

What is wrong with this connection string?

解决方案

try creating connection string this way:

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

}