0

I'm looking more and more about answer for my question.
When I open mysql query browser first time, there is place that we can create new mysql connection. I want to create connection like this.

In the 4 computers connected to a LAN network. I name these computers A,B,C,D for easy identiting on this example.
Think A is the only mysql installed computer and database server.
For other computers I installed program wich I made with vb.net 2012.
From that B,C,D computers When I entering data, I want to save those data to sql installed computer.
I have 2 question on this senario :
Q-1 : How would I write connection string ?
Previously I tried with this connection string :

con.ConnectionString = "User Id=root;server=192.168.8.101;password=mysql;database=moneycs"
(I dont sure this connection string)
**Q-2 : **How Could I make new mysql connection on server pc. (note : PC-A IP : 192.168.8.101)
making new connection page has these values and what would I put those values...
Connection :
Username:
Password:
Hostname
port:
schema:

So help me guys ! :)

2
Contributors
1
Reply
5
Views
1 Year
Discussion Span
Last Post by Shark_1
0

Your connection string should be

Server=192.168.8.101;Port=3306;Database=moneycs;Uid=root;
Pwd=mysql;

You can get more from this site.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.