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

     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.