Connect to a mysql db on another pc on the same network

Question

I have three pcs and each one runs xampp. I want the other two use the third pc's mysql database in order to have only one database for development and not three.. How should I setup my pcs to work like this?

Thanks in advance

jojo · Accepted Answer · 2011-04-07 09:42:12Z

1

Open the mysql connection on php code running on the first two pcs, setting for both the ip of third as db_host.

answered Apr 7, 2011 at 9:42

jojo

412 bronze badges

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

Comments

Oren Hizkiya · Accepted Answer · 2011-04-07 09:43:43Z

0

Configure a static IP for the computer hosting the database. When you use PHP to connect to the database from one of the other computers, set the host to this IP. Also make sure you have commented out #bind-address = 127.0.0.1 in my.ini as TJHeuvel noted.

answered Apr 7, 2011 at 9:43

Oren Hizkiya

4,4522 gold badges25 silver badges34 bronze badges

Comments

TJHeuvel · Accepted Answer · 2011-04-07 09:40:09Z

0

You'll have to change the my.ini to listen to TCP/IP, as described here http://www.howtogeek.com/howto/mysql/switch-mysql-to-listen-on-tcp/

answered Apr 7, 2011 at 9:40

TJHeuvel

12.6k4 gold badges40 silver badges46 bronze badges

Collectives™ on Stack Overflow

Connect to a mysql db on another pc on the same network

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related