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

["Michael Tubbe" <mtubbe@xxxxxxxxxxx>]

> } I remember a customer/friend alerting me (a couple of weeks ago) that he
> } could _see_ the names of all the databases. Only that he couldn't access
> } them or change them.
>
> Every installation of phpmyadmin that I've done, and I've done a few
> hundred installations, could see all of the databases hosted on the
> server.

If you don't want your users to see the other databases, read on.

I just finished an upgrade to 2.2.0.  It's set up so that the main admin can
see and manipulate all the databases, while other users can only see the
database they are allowed to see.  It has to do with records in the MySQL
database (the "user" and "db" tables).

If you follow the example in the FAQ
(http://phpmyadmin.sourceforge.net/documentation/#faq <-- thanks to Rik
Thomas for this URL), it should work for you also (although I cannot
guarantee any of this).  Search for:
"I'm an ISP. Can I set-up one central copy of phpMyAdmin or do I need to
install it for each customer?"
on the FAQ page.

There is another method that wasn't available in my last version, but is in
2.2.0.  To use it, go to the first phpMyAdmin screen.  On it, there is an
"users" option in the right-hand frame.  It will allow you to add a user (or
grant privileges to a current user).  I haven't tried it yet, but it should
do the same job as the FAQ example (only now it's front-end automated).

--
Michael Tubbe