When I enable DisableIS, in the navigation pane displays only the basic "information_schema" even if I place the base "information_schema" in the variable 'hide_db', it still appears in phpMyAdmin.
I'm logging in with user "james" and should have access to database "james", but in the list displays only the database "information_schema".
If I run the SQL: show databases;
Displays the bases correctly.
It was only with the GRANT USAGE and was not displaying. Configured with GRANT ALL and also is not displaying.
If I set the 'only_db' option, it displays my base correctly. But as my environment is shared hosting, I can not specify the database for every user.
I'm logging in with user "james" and should have access to database "james", but in the list displays only the database "information_schema".
If I run the SQL: show databases;
Displays the bases correctly.
Can you show us the output of the following query logged in as james?
SHOW GRANTS;
With the following grants I see both information_schema and james databases with DisabledIS.
GRANT USAGE ON
*
.*
TO 'james'@'localhost'GRANT ALL PRIVILEGES ON `james`.
*
TO 'james'@'localhost'Last edit: Madhura Jayaratne 2015-01-14
It was only with the GRANT USAGE and was not displaying. Configured with GRANT ALL and also is not displaying.
If I set the 'only_db' option, it displays my base correctly. But as my environment is shared hosting, I can not specify the database for every user.
I see both information_schema and james databases with the same grants.
Anyway hide_db directive is now adhered even when DisableIS is true.
https://github.com/phpmyadmin/phpmyadmin/commit/3fadd8d5ab3c60a446c936a9717ebffb55092536
Do you set hide_db and only_db from config.inc.php or from Settings panel?
I set hide_db and only_db in config.inc.php.
And works fine in dev branch
So you are using the GIT clone. How about the QA_4_3 branch? Can you test the improvements done regarding hide_db directive in that branch?
I tried the latest version in GIT and the problem continued