The recent update to phpMyAdmin 4.0.5 brought many unwelcome interface changes to the central phpMyAdmin that is accessed through WHM>SQL>phpMyAdmin
Changing this configuration is possible in phpMyAdmin on a session only basis, which is only helpful in limited circumstances.
Changing this configuration is possible in /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
However every upcp update will overwrite this file - I found this out only after spending half an hour editing only to find everything lost the next morning.
The recommended way to achieve this is by configuration storage. The process to set this up is hard to follow in many instances, for instance running examples/create-tables.sql will give an error on one of the tables it is trying to create, and any small mis-step can easily lead to being locked out of your WHM>SQL>phpMyAdmin (I found this out at the school of hard knocks as well).
What would be great is one of two things.
- Have the table for configuration storage already setup.
- Clear cPanel documentation on how to do this.
Thanks for considering this.