phpMyAdmin Tip Select ' prefs ' from ' phpmyadmin '. ' Pma_table_uiprefs ' ...

phpMyAdmin Click or Execute SQL statement display

SELECT `prefs`FROM `phpmyadmin`.`pma_table_uiprefs`WHERE `username` = ‘root‘AND `db_name` = ‘test‘AND `table_name` = ‘user‘MySQL reports: #1146 - Table ‘phpmyadmin.pma_table_uiprefs‘ doesn‘t exist



To resolve a step:
1. Find create_tables.sql.gz and Unzip
Command:
Locate create_tables.sql.gz
gzip-d Locate create_tables.sql.gz

2. Import this SQL file into the local database

3. Modify the config.inc.php file to change all the pma_ inside to pma__
For example: Pma_boolmark converted to Pma__bookmark