Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anugrahbsoe/da03583302295045abbfd9348ffb28ba to your computer and use it in GitHub Desktop.
Save anugrahbsoe/da03583302295045abbfd9348ffb28ba to your computer and use it in GitHub Desktop.
Problems : phpmyadmin.pma_table_uiprefs doesn't exist
Solved :
1. Edit /etc/phpmyadmin/config.inc.php and change this rows:
$i]['pma__bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['pma__relation'] = 'pma__relation';
$cfg['Servers'][$i]['pma__table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['pma__table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pma__pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['pma__column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['pma__history'] = 'pma__history';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['pma__designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['pma__tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['pma__userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['pma__recent'] = 'pma__recent';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
2. If you are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.
a. Just download create_table.sql from GitHub <https://raw.githubusercontent.com/phpmyadmin/phpmyadmin/master/sql/create_tables.sql>
b. and save that file in your system.
c. Then go to your phpMyAdmin.
d. And click on Import from upper tab.
e. At last select create_table.sql and upload that.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment