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;
GRANT ALL PRIVILEGES ON mydatabase.* TO [EMAIL PROTECTED]
IDENTIFIED BY mypassword;
Remember that you need admin access to set this up.
"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?
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]