Can connect to mySql server via php but not with c# [duplicate]

Question

As I wrote in the topic, this works totally fine:

mysql_connect("server","username","password");

But this doesn't:

MySql.Data.MySqlClient.MySqlConnection connection =
   new MySql.Data.MySqlClient.MySqlConnection("SERVER=server;DATABASE=database;UID=username;PASSWORD=password;");
connection.Open();

The exception is always

Unable to connect to any of the specified MySQL hosts

And no, the question is neither a duplicate, nor answered there

connectionstrings.com/mysql - PASSWORD should be pwd. Better yet use MySqlConnectionStringBuilder so you don't have to worry about the details of the connection string, as per the answer in the question that I'm about to mark this a dupe of. — Preston Guillot
– Preston Guillot, Commented Feb 11, 2015 at 17:34
I just tried to connect with using the StringBuilder but the same error still appears... — 91378246
– 91378246, Commented Feb 11, 2015 at 17:42

nvoigt · Accepted Answer · 2015-02-11 17:33:59Z

1

As per the documentation, this

"SERVER=server;DATABASE=database;UID=username;PASSWORD=password;"

should be

"SERVER=server;DATABASE=database;UID=username;PWD=password;"

answered Feb 11, 2015 at 17:33

nvoigt

77.8k28 gold badges103 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

91378246 Over a year ago

I tried the string on another database server and it worked fine there...

Collectives™ on Stack Overflow

Can connect to mySql server via php but not with c# [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related