Re: [cobalt-users] PHPMyAdmin

["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-users@xxxxxxxxxxxxxxx>
Sent: Sunday, September 29, 2002 7:24 AM
Subject: [cobalt-users] PHPMyAdmin


> Someone mentioned a possible way to install phpMyAdmin to that one copy
> services all users(sites).
>
> I'd love to see the specific how-to...I have a LOT of folks installing it,
> and one central copy might make sense.
>
> thanks
> Thom
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>