Hey.
Do you mean that you want to use the same database, hosted on a Linux server, on two PHP installations, each hosted on a separate Windows XP machine?
Please note that a MySQL user is not limited to a single machine. You can use a single user for any number of connections, from any number of locations.
For example, if you wanted to access a MySQL database from two computers, both of them belonging to the same local network that the MySQL server itself was hosted on. You could create this user:
- GRANT ALL
-
ON database.table
-
TO 'MyUser'@'192.168.%.%'
-
IDENTIFIED BY 'Password';
And this user could be to connect from both systems.
However, since you are using two machines, you could just as well create two separate users, one for each machine. Then you could specify the exact IP address, making things that much secure.
Also, you should try not to grant ALL privileges to a remove connection. Do administrative work from the localhost, and grant limited privileges to remote machines.
