Menu

#4704 DisableIS enabled, only shows information_schema db.

4.3.6
pending
Normal
2015-03-26
2015-01-13
j4m3sbr
No

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 using phpmyadmin 4.3.6.

Discussion

  • j4m3sbr

    j4m3sbr - 2015-01-13

    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.

     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    Can you show us the output of the following query logged in as james?

    SHOW GRANTS;

     
  • Madhura Jayaratne

    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
  • Madhura Jayaratne

    • status: open --> pending
     
  • j4m3sbr

    j4m3sbr - 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.

     
  • Madhura Jayaratne

    • status: pending --> open
     
  • Madhura Jayaratne

    I see both information_schema and james databases with the same grants.

     
  • Madhura Jayaratne

    Do you set hide_db and only_db from config.inc.php or from Settings panel?

     
  • Madhura Jayaratne

    • status: open --> pending
     
  • j4m3sbr

    j4m3sbr - 2015-01-23

    I set hide_db and only_db in config.inc.php.

    And works fine in dev branch

     
  • Madhura Jayaratne

    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?

     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 6 --> Normal
     
  • j4m3sbr

    j4m3sbr - 2015-03-26

    I tried the latest version in GIT and the problem continued