PHPMyAdmin 3.x hides the table indexes

Users of PHPMyAdmin 3.x may find that the table indexes are automatically hidden at the bottom of the page. I find this to be a huge annoyance since table indexes are tremendously important to the structure of the table.

If you don't want to downgrade to PHPMyAdmin 2.x, just add the following line to the top of your config.inc.php file:

$cfg['InitialSlidersState'] = 'open';

This will cause the indexes to be displayed when you click Structure for a certain table. By default, they are hidden.

Sidenote: Some of you might be thinking: "Hey, you're a DBA, you should know MySQL queries without needing PHPMyAdmin." You're right. I do know how to get the job done without PHPMyAdmin, but I enjoy the way PHPMyAdmin allows me to visualize my table structures. Also, it's a handy way to present data to others very quickly.

Printed from: http://rackerhacker.com/2009/04/03/phpmyadmin-3x-hides-the-table-indexes/ .
© Major Hayden 2012.

Leave a Reply

 

  • Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you find the information useful. If you spot something that's incorrect or confusing, please write a comment and let me know. Drop me a line if there's something you want to know more about and I'll do my best to write a post on the topic.
    -- Major Hayden

    Flattr this