RE: [cobalt-users] phpMyAdmin on a Raq 550

["Mark Middleton" <mark@xxxxxxxxxxxxxx>]

> > > Easiest way:
> > > Download phpmyadmin 2.2.6
> > > tar.gz
> > > Unzip
> > > Edit config.inc ( http as auth. Method + the absolute url) Upload
> >
> > But does it enable the one feature I want? Users only seeing THEIR
> > database?

Yes, the user will only see their database - *IF* their username only has
the granted permissions to see their database.
Using phpMyAdmin's feature to authenticate via http works well for us.

In short, we have setup one copy of phpMyAdmin on the server, and set a
server-wide alias for /sql to the location.

When they go to www.theirdomain.com/sql they are prompted to enter their
username and password - which authenticates and shows them ONLY the
database(s) they have authority to view.

To give a customer MySQL access, I simply add a new database for them,
create a new user for them, and give them grants to view and edit their
database only.

It's given use extreme flexibility and compartmentation.

(note that versions of phpMyAdmin after 2.2.5 REQUIRE a specific domain name
entered in the config.inc - which has prevented us from upgrading
phpMyAdmin)

I hope this helps!
-Mark

~~~~~~~~~~~~~~~~~~~~
Mark Middleton
Whirled Web
mark@xxxxxxxxxxxxxx