Database sharing

[GoldenMerc]

How would i share a database between two severs, Sever 1 is the site it needs from the database - Usergroup, Username
Sever 2 has the sever. im wanting sever 1 to pull it from sever two, how would i go about doing this?
Ross

[Source]

You would enable remote connections on mysql, so it would accept connections through an IP rather than localhost.

That way you can just configure your script to connect to a database on another server.

[GoldenMerc]

Righttt, do you have any instructions on how id do that :D
Ross

[Tomm]

You want server one to allow connections from server two or do you want server two to copy the data from server one (http://dev.mysql.com/doc/refman/5.0/en/replication.html)?

[GoldenMerc]

I want sever one to pull data from sever two :P