How to connect 2 computers on same MySQL database that is instaled on one computer.
Computers are connected on LAN
2 computers on same MySQL database
Moderator: General Moderators
First make sure networking is enabled in your configuration file, then add a remote user like so:
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'
Code: Select all
GRANT ALL PRIVILEGES ON db.* TO user@192.168.1.1 IDENTIFIED BY 'password' WITH GRANT OPTION- tasteslikepurple
- Forum Commoner
- Posts: 46
- Joined: Thu Jan 26, 2006 3:38 am
- Location: Bath, UK