Re: sharing data stored in mysql with another site

From: 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 >

« previous php.general (#72965) next »