How can I set a default sort for tables in PHPMyAdmin (i.e. always "Primary key - Descending")
For anyone else who comes here looking for an answer:
In phpMyAdmin 4.5.0, maybe in earlier versions too, you can set the $cfg['TablePrimaryKeyOrder'] config like so:
$cfg['TablePrimaryKeyOrder'] = 'DESC';
This defines the default sort order for the tables, having a primary key, when there is no sort order defines externally. Acceptable values : [‘NONE’, ‘ASC’, ‘DESC’]
This sets the default sort if the table has a primary key and that no other sort has been applied to it.
You can save a private bookmark with the name of the table you're browsing.
See https://phpmyadmin.readthedocs.org/en/latest/faq.html#bookmarks-can-i-execute-a-default-bookmark-automatically-when-entering-browse-mode-for-a-table
6.22 Bookmarks: Can I execute a default bookmark automatically when entering Browse mode for a table?
Yes. If a bookmark has the same label as a table name and it’s not a public bookmark, it will be executed.
i think you can do this. Go to a table -> operations and set alter table order by descending. Next time when ever you browse you get the newest row first.