If the other site is on the same server, you can use the same method to log in (same username and password). If it's on a separate computer you need to either create a new user or change the existing user to have remote access. To create a user with remote access:
GRANT [privileges] ON [database.table[, database.table, ... ]] TO user@host IDENTIFIED BY password; Example: GRANT ALL PRIVILEGES ON mydatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY mypassword; Remember that you need admin access to set this up. Mike "Matthew Delmarter" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have developed a site using PHP and MySQL. > > My question: > How do I share the data stored in the database with another site? > > Regards, > > Matthew > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
