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