What I searched for
Why I searched for it
I swear this used to be the default behavior, but now (using phpMyAdmin 4.6.4 and MAMP 4.0.5—which turns out to be relevant) clicking a table name in the left sidebar opens up the “Structure” tab. 95% of the time I want to see the data and it was making me crazy to have to manually switch it each time.
What I learned
This can be changed in MAMP’s phpMyAdmin config file (for me, located at
/Applications/MAMP/bin/phpMyAdmin/config.inc.php) by updating the
$cfg['DefaultTabTable'] setting to
'sql.php' (even though that’s not listed under the “Possible values:” heading!).
After I figured this out, I found this relevant StackOverflow question, which may be helpful if this sounds like the right path but you need a little more.