Which Query is used to share the two mysql database system in windows XP?

[sganeshsvk]

sir,

Suppose we want to share the two Linux system in mysql database then we using GRANT ALL PRIVILEGES query for access permission between two System Databases.

Likely i want to share the two WindowsXP system in mysql database then how to access this permission.

Actually i installed the PHP 2.0.1 in WindowsXP then MySQL atomically installed.

So, i want to share this two WindowsXP system in mysql for share the access database.

Please, give the procedure steps for me to access permission in mysql databases in between two windowsXP system....

[Atli]

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.