How can I make phpMyAdmin 4.0.8 behavior like it used to listing all tables so it doesn't do this:
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.
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.
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.
Sounds like you wish to set NavigationTreeEnableGrouping
= false;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With