Question how to get data from mysql that is install at other computer in LAN?

[kinki_2046]

Dear all,

How to get data from mysql which was install at other computer in the LAN network? What should I configure in the mysql or the vb.net program?
Summary: Multi users to use the same database at a LAN Network

Database: mysql
program: vb.net
Network: LAN

Please provide me the step.


Thanks.

 

[jmcilhinney]

Data access is the same regardless of the location of the database. All that changes is the connection string. Visit ConnectionStrings.com to find the appropriate connection string format.

 

[Menthos]

Just specify the machine hosting the db - MySQL Connection String Samples - ConnectionStrings.com should help you get connected.

Can't recall off the top of my head whether you'd need to allow remote access on the db side.

 

[kinki_2046]

re

Thanks for the both replier.
I had view the page but I didn't which should I get it, it was too many.

Example:
I had 2 computer
computer 1 IP address: 192.168.1.5 (Mysql Located)
computer 2 IP address: 192.168.1.6


Izzit I need to set for the computer2 the connection string.

Server=192.168.1.5;Database=hotel_data;Uid=root;Pwd=root123;

If I was wrong, please correct me.

Thanks a lot.

 

[Menthos]

That certainly looks like it should work (minus the space in the Pwd clause)

 

[kinki_2046]

Dear Menthos,

Are we no need to setting any thing when install the mySQL for allow the Lan accessing?

THanks.

 

[Menthos]

Long time since I've messed around with mySQL...try googling 'allowing remote connections to mySQL'

 

[milosh]

You must to add privileges on database, and allow in firewall, mysql port 3306 on computer where is installed mysql server.