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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > > -- > [EMAIL PROTECTED] Thom LaCosta K3HRN > http://www.baltimoremd.com/cobaltfacts/ > CobaltFacts Web Ring - cobalt-ot and hosting-biz mailing lists > > _______________________________________________ > cobalt-developers mailing list > [EMAIL PROTECTED] > http://list.cobalt.com/mailman/listinfo/cobalt-developers > _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
