Page 1 of 1

2 computers on same MySQL database

Posted: Mon Feb 20, 2006 12:40 pm
by ddragas
How to connect 2 computers on same MySQL database that is instaled on one computer.
Computers are connected on LAN

Posted: Mon Feb 20, 2006 12:42 pm
by josh
First make sure networking is enabled in your configuration file, then add a remote user like so:

Code: Select all

GRANT ALL PRIVILEGES ON db.* TO user@192.168.1.1 IDENTIFIED BY 'password' WITH GRANT OPTION
obviously put your IP and all that in, you can now connect to this server just use it's IP as the hostname instead of the usual 'localhost'

Posted: Mon Feb 20, 2006 1:06 pm
by ddragas
It's working

Thank you

Posted: Thu Mar 23, 2006 2:38 am
by ddragas
If I install database on disk drive "G:" will all above work?

Posted: Thu Mar 23, 2006 9:27 am
by tasteslikepurple
aslong as mysql is installed, working, and running, it will still work. i.e. if you can access the database on the computer it's installed on drive G, it will still work on the networked computer