Re: [cobalt-developers] phpMyAdmin on RAQ4i

["Shaun Johnston" <shaun@xxxxxxxxxxxxxxxx>]

To set up 'cookie' or 'http' authentication mode (the only useful
authentication methods for a cross-domain phpMyAdmin installation), you need
to set up a mysql user with _only select_ access to the mysql.user, mysql.db
and mysql.tables_priv tables.

To do this, follow the instructions at
http://www.phpmyadmin.net/documentation/ (look for the heading 'Using
authentication modes').

To set phpMyAdmin up so it serves multiple domains, you need to delve into
your srm.conf file (located at /etc/httpd/conf/srm.conf), so be sure to make
a backup before making any changes.

All you need to add to srm.conf is:

Alias /[name of virtual directory you want people to access] [path to
phpMyAdmin installation]

So for example - if I added a subdomain to mydomain.com specifically for
phpmyadmin, called mysql.mydomain.com, its path would be
/home/sites/mysql.mydomain.com/web, and my line in srm.conf would look like
this:

Alias /mysqladmin /home/sites/mysql.mydomain.com/web/

After that's added and apache is restarted (/etc/rc.d/init.d/httpd restart),
any domain on your server can access the phpmyadmin installation simply by
going to www.theirdomain.com/mysqladmin. Of course, they could also access
the same installation by going to mysql.mydomain.com.

Hopefully that helps :-)

----- Original Message -----
From: "Thom LaCosta" <baltimoremd@xxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Sunday, September 29, 2002 7:45 AM
Subject: Re: [cobalt-developers] phpMyAdmin on RAQ4i


> On Sat, 28 Sep 2002, Shaun Johnston wrote:
>
> > Needs practically no configuration apart from the settings you need to
add
> > in the config.inc.php file.
> >
> > It can be placed anywhere that's under a web root.
> >
> > If you want to get fancy, you can use an alias in the apache config to
make
> > a single installation of phpMyAdmin work across multiple domains (using
its
> > cookie authentication method, so different users access only the
databases
> > applicable to them).
>
> I'm obtuse...can ya give some more detail on how one might set that up on
> a RaQ4 ?
>
> Thanks
>
> Thom
>
> --
> baltimoremd@xxxxxxxxxxxxxxx             Thom LaCosta K3HRN
> http://www.baltimoremd.com/cobaltfacts/
> CobaltFacts Web Ring - cobalt-ot and hosting-biz mailing lists
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>