How to connect to a distant mysql database using asp.net [duplicate]

Question

I want to connect to a disant mysql database wich is located in another server using Asp.net C#. How can i did it ? Thanks.

i think its easier to type the same title in google than SO. — It's a trap
– It's a trap, Commented Jul 27, 2016 at 8:02

Igor Damiani · Accepted Answer · 2016-07-27 07:57:03Z

0

You need this code:

var myConnectionString = "server=127.0.0.1;uid=root;pwd=12345;database=test;";
var conn = new MySqlConnection(myConnectionString);
conn.Open();

Also you need the public IP of the MySql server and the correct credentials (userid, password and database name).

answered Jul 27, 2016 at 7:57

Igor Damiani

1,92711 silver badges13 bronze badges

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

2 Comments

as additional info: it's important, that your IP is allowed to connect to the distant mysql-server by the server. Can be a pun not knowing this.

i'll try it. thanks :)