i have 4 pc connected through a hub and i want to connect them for a use of single data base by my sql. how we can do this so that they use a sinle data base
4 pc connected through a hub how they can use a common mysql server for data base
Collapse
X
-
Assuming the network communication between 4 PCs are good...
- Install MySQL one PC and make sure TCP port 3306 on that PC is open to the network
- Create a MySQL user that can access the MySQL instance from outside the localhost. See here
- On other PCs, install MySQL client libraries. These may vary based on what software you use to access the database. You may some dimes need ODBC drivers also. See here
You should be good to go.
Comment