Re: mySQL - using same db for two domains

Sure you can "grant" rights for a user @ a host.  The problem may be
logistics and deviation from their standard operating procedure.  What web
based program are you using to admin your database?  Are both sites on the
same box?

If your interface currently has grant privileges and access to the mysql
tables then you can add these privileges:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Privil
eges_provided

like this:
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Adding
_users

Consider this......................
Don't give the new user any privileges the program does not need.   If
select or insert will do then go no further.
Be careful with the host designations.  You could open up connections you do
not want.

My parting piece of advice is to go armed with the above information and use
it as talking points to have your host do it.  They have the "big picture"
of their server farm and could best implement this in a secure fashion.


----- Original Message -----
From: "Sue Bailey" <sue(at)bartandsue.co.uk>
To: <hwg-techniques(at)hwg.org>
Sent: Thursday, November 23, 2000 4:24 PM
Subject: mySQL - using same db for two domains


> Hope someone here can help me with this, because my ISP can't!!
>
> I have a MySQL database set up for domain one, which I also want to use
for
> domain two. When (using PHP) I try to connect from domain two, I'm told
that
> access is denied (using domain two's user name and p/w) or just nothing
> happens (using domain one's). Is it possible to set the permissions so
that
> domain two does have access rights? If so, how?
>
> Bearing in mind - I don't have telnet access to this server.
>
> TIA
>
> Sue
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA