Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin show all tables not separated into views and tables

How can I make phpMyAdmin 4.0.8 behavior like it used to listing all tables so it doesn't do this:

enter image description here

I have been reading all the old posts and so far in my config I have added all of these but still have to keep clicking the expand tables every 2 minutes.

$cfg['ShowPhpInfo'] = true;
$cfg['ShowAll'] = true; // Enable display all the rows
$cfg['MaxRows'] = 50; // Maximum number of rows to display
$cfg['MaxDbList'] = 1000; // Maximum databases displayed per page
$cfg['MaxNavigationItems'] = 1000; // Maximum navigation items per list
$cfg['MaxTableList'] = 1000; // Maximum tables displayed per page
$cfg['NavigationTreeDBSeparator']  = ''; // Disable prefix removal
$cfg['NumRecentTables'] = 100; // Number of recently used tables. Set this to 0 (zero) to disable the listing of recent tables.
$cfg['LoginCookieValidity'] = 604800; // Prevent timeout for a week 
$cfg['NavigationTreeEnableGrouping'] = false; // Group the databases based on a common prefix in their name 
$cfg['NavigationDisplayLogo'] = false; // Hide logo
$cfg['NavigationTreeDisplayItemFilterMinimum'] = 9999; // Minimum number of items (tables, views, routines and events) to display a JavaScript filter box above the list of items in the navigation tree.
$cfg['NavigationTreeDisplayDbFilterMinimum'] = 9999; // Minimum number of databases to display a JavaScript filter box above the list of databases in the navigation tree.
like image 744
John Magnolia Avatar asked Nov 12 '13 12:11

John Magnolia


People also ask

How do I display tables in phpMyAdmin?

Choose the Database User and click phpMyAdmin. On the left pane of your phpMyAdmin page, click on the Database User. Click on the table to display the Structure page for the table.

Why database is not showing in phpMyAdmin?

Your app is probably connected using a different, lower privileged user. Try running select user(); from your app and from phpMyAdmin and you will know for sure. Assuming your app is running with a different user, you will need to add privilages for it to access the database you create.


1 Answers

Sounds like you wish to set NavigationTreeEnableGrouping= false;

like image 93
Isaac Bennetch Avatar answered Sep 17 '22 20:09

Isaac Bennetch