Posted by J.O. Aho on 05/31/06 03:52

©® wrote:
> I have a few MySQL databases that came with my hosting package.
> My friend has very simple webhosting and did not get any databases.
> How do I allow him access to one of my databases? (I will create one for
> his specific use).
> Many times it asks for the direct path to the database but AFAIK this is
> from my hosting. I guess I need to know how to point from his site to my
> site with the database.

You need to have the right to use the GRANT sql-function in the database
http://dev.mysql.com/doc/refman/5.0/en/grant.html

But as everyone else already said, you won't.

You could make a "wrapper" php-script that your friend can call, which does
the sql queries for him on your database. But this will be a security problem
for you and will make your friends php-scripts a bit harder to write.



//Aho

[Back to original message]