c# connect into MySQL

Question

I'm trying to connect MySQL in C# develope in Expression Blend 4 but i get following error ?

try { string serverConnection = "SERVER=xxx.xxx.xxx.xxx; UID=xxx; PASSWORD=xxx; DATABASE=xxx;"; MySqlConnection conn = new MySqlConnection(serverConnection); conn.Open(); MessageBox.Show("Successfully connected"); conn.Close(); } catch (Exception ex) { MessageBox.Show("Error:"+ex.Message); }

Here is the error:

Unable to connect to any of the specified MySQL hosts

Any inner exception? can you connect to mySql from another MySQL Managers? — Jaime García Pérez
– Jaime García Pérez, Commented Apr 8, 2015 at 16:42
Yes it works fine in another. There is one exception here conn.Open(); — Orgil
– Orgil, Commented Apr 9, 2015 at 2:21
Yes it is, local server worked but remote server says these error — Orgil
– Orgil, Commented Apr 9, 2015 at 7:07
Did you config your MySQl to accept remote connections to your IP? you need to grant permissions first. cyberciti.biz/tips/… — Jaime García Pérez
– Jaime García Pérez, Commented Apr 9, 2015 at 7:14

Sean Mitchell · Accepted Answer · 2017-08-21 00:54:46Z

The format for connection strings is as follows,

Server=myServerAddress; Port=1234; Database=myDataBase; Uid=myUsername; Pwd=myPassword;

The most likely issue is that you are trying to remotely connect to your MySQL server in which case make sure it allows for remote connections, and then you must check and make sure the user you are trying to login as is allowed to connect from either your public IP or any public IP.

NOTE: I know this response is 2 and 1/3 years late, but I wanted this to be here for anyone else with a similar issue.

Rahul Tripathi · Accepted Answer · 2015-04-08 15:34:09Z

I think its more of like the placement of the parameters.

The standard format specified is this:

Server=myServerAddress; Port=1234; Database=myDataBase; Uid=myUsername; Pwd=myPassword;

You need to change it like this:

string serverConnection = "SERVER=xxx.xxx.xxx.xxx; DATABASE=xxx; UID=xxx; PASSWORD=xxx;";

Try to change and see if that works :)

Collectives™ on Stack Overflow

c# connect into MySQL

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related