Connection String to MySQL Database on LAN Setup

Question

With the service running on my machine(Setup on a LAN with no internet connection), I can connect with the following :

string sConnection = @"Server=localhost; Port=3306; Database=some_database; Uid=root; Pwd=genericpassword;";

MySqlConnection cnTest = new MySqlConnection(sConnection);

cnTest.Open();

How should I Modify my connection string to connect from another PC on the lan to my MYSQL server? *side note : The IP of my local machine is setup to be 192.168.0.1.

checkout this, connection strings should be stored / maintained in something like a .Config file connectionstrings.com/mysql-connector-net-mysqlconnection — MethodMan
– MethodMan, Commented Nov 12, 2014 at 17:28

Haedrian · Accepted Answer · 2014-11-12 17:29:43Z

1

What goes after "Server=" is the address of the server.

So if your server is on 192.168.0.1 - it'll look like

string sConnection = @"Server=192.168.0.1; Port=3306; Database=some_database; Uid=root; Pwd=genericpassword;";

Just replace 'localhost' with the address you're given.

That said, it's generally considered to be good procedure to store connection strings in web.config / app.config - whenever you deploy it on some other environment, you won't want to rebuild it. This link might help with that.

answered Nov 12, 2014 at 17:29

Haedrian

4,3202 gold badges36 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Connection String to MySQL Database on LAN Setup

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related