[Phpmyadmin-devel] testing bookmarks

[Armel FAUVEAU]

Hi all,

> what are the privileges required for a normal user X to be able to use
> the bookmark features?
>
> I added select, insert, update, delete, index, alter to this user X for
> database bookmark, table bookmark, and he does not see the bookmarks.
>
> However a user A with global privileges was able to create bookmarks on
> the database X.
>
> User X, in mysql, can see the bookmarks.

I think that your config.inc.php look like this :

$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '';
$cfgServers[1]['adv_auth'] = true;
$cfgServers[1]['stduser'] = 'xxxx';
$cfgServers[1]['stdpass'] = 'yyyy';
$cfgServers[1]['user'] = '';
$cfgServers[1]['password'] = '';
$cfgServers[1]['only_db'] = '';
$cfgServers[1]['verbose'] = '';
$cfgServers[1]['bookmarkdb'] = 'bookmarkdb';
$cfgServers[1]['bookmarktable'] = 'bookmarktable';

This not work :(

If you want to use bookmark in adv_auth for others users, you must add a new
$cfgServer section :

$cfgServers[2]['host'] = 'localhost';
$cfgServers[2]['port'] = '';
$cfgServers[2]['adv_auth'] = true;
$cfgServers[2]['stduser'] = 'anotheruser';
$cfgServers[2]['stdpass'] = 'anotherpass';
$cfgServers[2]['user'] = '';
$cfgServers[2]['password'] = '';
$cfgServers[2]['only_db'] = '';
$cfgServers[2]['verbose'] = '';
$cfgServers[2]['bookmarkdb'] = 'bookmarkdb';
$cfgServers[2]['bookmarktable'] = 'bookmarktable';

Yes, it's not perfect :(
But, because of security, i think it's much better (all users don't share
the same bookmark table).
If you are another idea, i'm opened :)

Yours.
................................................................
Webmaster PHPIndex
http://www.phpindex.com
webmaster at phpindex.com
................................................................