How can I connect to my MySql DB on godadday from my C# application? I tried looking for settings to enable this and cannot find it. Also what IP address should I be using? I'm connecting to my site using the IP address given to me with and without port 3306 to no success.
ERROR: I x'ed out the server ip and user
An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll
Additional information: Authentication to host 'xxx.xx.xxx.xxx' for user 'xxxxx' using method 'mysql_native_password' failed with message: Access denied for user 'xxxxx'@'c-73-12-216-99.hsd1.ca.comcast.net' (using password: YES)
CODE:
public static bool Connect(string userName, string password, string server, string database)
{
MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();
conn_string.Server = server;
conn_string.UserID = userName;
conn_string.Password = password;
conn_string.Database = database;
conn_string.Port = 3306;
string con = conn_string.ToString();
using (MySqlConnection conn = new MySqlConnection(con))
using (MySqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.ExecuteNonQuery();
}
return true;
}
Aucun commentaire:
Enregistrer un commentaire