Re: [cobalt-users] Re: phpMyAdmin multi-user

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"JM" <jm@xxxxxxxxx> wrote:
> > You can set the 'only_db' variable in the
> > conf.ini.php3 script to the name of the only database you wish the
> > user to view.
>
> Is there a way to set the 'only_db' option to allow multiple databases? I
> have a client with 5 databases, and I would like to set it up so that they
> only see those 5. I tried separating with a comma, and adding a second
> 'only_db' option. Neither worked.

If you want multiple dbs they need to be in an array.

$cfgServers[1]['only_db'] = array( 'db1', 'db2', 'db3', 'db4', 'db5' );

IMO advanced authentication is a better solution.  See my previous post from
yesterday on the subject.  With advanced authentication you can create new
dbs for a user and they'll automatically have access through phpMyAdmin
without reconfiguration.  One caveat is that any MySQL user on the box will
be able to access their dbs through the software and if you charge extra for
such access or don't want them doing so through another user's site it's not
the way to go.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/