Re: [cobalt-users] raq mysql for each user/domain

["Andras Kende" <andras@xxxxxxxxx>]

----- Original Message ----- 
From: "Michael Karner" <m7000@xxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Saturday, June 01, 2002 1:39 AM
Subject: [cobalt-users] raq mysql for each user/domain


> hi !
> 
> Is it possible to configure mysql on my raq4i for each user ?
> so that everyone can go to mydomain.xxx/phpmyadmin
> and login with a seperate user/password to manage ONLY
> his own database ?
> 
> 
> thanx
> MiKE
> 


Mike,

I put phpmyadmin on my main site but probably can be done in the 
apache config...
I guess its like:
/etc/httpd/conf/srm.conf
Alias /phpmyadmin /home/sites/site1/web/phpmyadmin

Not if its works sure because of the $cfgPmaAbsoluteUri setinngs at the 
phpmyadmin...

Install latest phpmyadmin from phpmyadmin.net 
change auth method to http in config.inc.php
$cfgServers[$i]['auth_type']     = 'http';    // Authentication method

Mysql setup at phpmyadmin: 
1. Create user database.
2. Create user with no privileges at all
3 Grant privileges for user on his/her database only

This way your user will only see and access their own databases in 
phpmyadmin

Best regards,

Andras Kende