Re: sharing data stored in mysql with another site
| From: | Mike Frazer | Date: | Wed, 31 Oct 2001 05:01:38 +0000 |
| Subject: | Re: sharing data stored in mysql with another site | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72965@lists.php.net to get a copy of this message | ||
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 myuser@some.remote.host.net
IDENTIFIED BY mypassword;
Remember that you need admin access to set this up.
Mike
"Matthew Delmarter" <matt@adplusonline.com> wrote in message
news:NDBBKBIHLCDMDICHLDKGMEPCCHAA.matt@adplusonline.com...
> 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
>