phpmyadmin.pma_table_uiprefs doesn't exist

I searched the internet but cannot find anything related to this specific error/table. It pops up when I try to view a table in phpMyAdmin. I am logged in as root and the installation (under ubuntu 13.10) of phpMyAdmin is fresh and untouched so far.

Here is the whole message:

SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'root'
AND `db_name` = 'symfony'
AND `table_name` = 'users'

MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

Is the installation just broken or am I missing something?

You are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.

See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage.

A quick summary of what to do can be:

1. On the shell: locate create_tables.sql.
2. import /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz using phpMyAdmin.
3. open /etc/phpmyadmin/config.inc.php and edit lines 81-92: change pma_bookmark to pma__bookmark and so on.

I came across this same problem on Ubuntu 13.10. I didn't want to hack PHP files, because normally phpMyAdmin works out of the box after installing the package from Ubuntu repositories. Instead I ran:

sudo dpkg-reconfigure phpmyadmin

During reconfigure, I said "yes" to reinstalling the phpMyAdmin database. Afterwards, the problem was gone. I have a vague memory of answering "No" to that question at some earlier time, during an install or upgrade. That is probably why the problem occurred in the first place.

You just change following line in /etc/phpmyadmin/config.inc.php

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

to

$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

And restart apache server with command,

sudo service apache2 restart

Try sudo dpkg-reconfigure phpmyadmin

To Replace config file /etc/phpmyadmin/config-db.php with new version

I had to change this rows:

$cfg['Servers'][$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';

add: "pma__" to ['bookmarktable'] and "_" to 'pma_bookmark'

you should reconfigure the phpmyadmin On terminal:

• sudo dpkg-reconfigure phpmyadmin

I found a solution to fix this.

Edit your /etc/phpmyadmin/config.inc.php file.

Find:

if (!empty($dbport) || $dbserver != 'localhost') {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    }

Add after:

$cfg['Servers'][$i]['pmadb'] = null; // Apurba

Restart your apache service and try. Hope it helps. Thanks.

I had the same problem with latest Lampp with MariaDB on Ubuntu Server 14.04, and @iceberg's solution worked very well:

>You just change following line in /etc/phpmyadmin/config.inc.php > > $ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’; > >to > > $ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’; > >And restart apache server with command, > > sudo service apache2 restart

Lampp config.inc.php is located in /opt/lampp/phpmyadmin/config.inc.php and to make it work, I also needed to change

$ cfg ['Servers'] [$ i] ['tracking'] = ‘pma__tracking’;

to

$ cfg ['Servers'] [$ i] ['pma__tracking'] = ‘pma__tracking’;

and restart the lampp:

sudo /opt/lampp/lampp stop
sudo /opt/lampp/lampp start

I use Windows 7 Xampp's version of phpmyadmin and none of the above, or below if this post gets upvoted, answers worked. I have tried uninstalling Xampp and upgrading to a higher version, manually changing values in the config folder, importing .sql files from some github page, and even viewing youtube videos but none of the suggestions worked.

Solution:

Delete EVERYTHING in the C:\xampp\phpMyAdmin folder > go to https://www.phpmyadmin.net/ and download the latest version > extract everything to the C:\xampp\phpMyAdmin folder and your problem is solved.

^^^^^ Read this if you don't want to waste hours searching Google for tons of failed solutions. It's far simpler too! ^^^^^^

Into phpmyadmin database's create that table, there miskta on name of that table it may be pma_table_uiprefs and not pma__table_uiprefs

> CREATE TABLE IF NOT EXISTS pma_table_uiprefs ( username > varchar(64) NOT NULL, db_name varchar(64) NOT NULL, table_name > varchar(64) NOT NULL, prefs text NOT NULL, last_update > timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE > CURRENT_TIMESTAMP, PRIMARY KEY (username,db_name,table_name) ) > COMMENT='Tables'' UI preferences' DEFAULT CHARACTER SET utf8 COLLATE > utf8_bin;

Steps:

• Just download create_table.sql from GitHub and save that file in your system.
• Then go to your phpMyAdmin.
• And click on Import from upper tab.
• At last select create_table.sql and upload that.

After all it works for me and hopefully work for you.

in linux os such as Debian or Ubutu you can simply try this ways, for first time remove phpmyadmin with --purge parameter:

sudo apt-get remove --purge phpmyadmin

then install again

sudo apt-get install phpmyadmin      

thats work fine :)

You just need to change the table names as per the error in - /etc/phpmyadmin/config.inc.php

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

to

$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma__table_uiprefs’;

assign the table names accordingly and everything will be fine.

For me,sudo dpkg-reconfigure phpmyadmin caused more trouble when I chose the option to re-install the database

A really simple solution is to edit /etc/phpmyadmin/config.inc.php and put

$cfg['Servers'][$i]['table_uiprefs'] = '';

It just manages the UI and who needs the UI if its interfering with display of actual data.

cheers

Clear your cookies

When using PHPMyAdmin configured with multiple databases, one having the phpmyadmin table and another not having it; phpmyadmin will store preferences for the database with the table in your cookies then try to load them with the database that doesn't have the table.

To test, try using an incognito window.

I just located the create_tables.sql, saved to my desktop, opened phpMyAdmin, selected the import tab, selected the create_tables.sql, clicked ok

To elaborate on multiple reply here above, there is an error in the config.inc.php shipped, where a "_" is missing, which is what this reply sais.

To fix that, you can add a "pma__table_uiprefs.inc.php" in the "/etc/phpmyadmin/conf.d" folder, leaving main configuration files untouched...

<?php foreach($cfg['Servers'] as $i => $v) { $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; }

I had similar problems with phpMyAdmin after changing Mysql InnoDB setting to innodb_file_per_table = 1
to move InnoDB tables into separate files.

None of the other answers helped in my case, neither sudo dpkg-reconfigure phpmyadmin nor importing create_tables.sql. Both failed.

What helped was making sure no default-storage-engine, default-tmp-storage-engine and innodb_file_format is enforced in my.cnf

After restarting MySQL and removing+reinstalling phpMyAdmin there are no more errors.

Commented out whole config section(/etc/phpmyadmin/config.inc.php):

from:

/* Optional: Advanced phpMyAdmin features */

to:

/* Optional: Advanced phpMyAdmin features

I just needed simple acces to data ... This problem shouldn't be blocking for phpmyadmin displaying tables ...

For ubuntu me help - sudo dpkg-reconfigure phpmyadmin

Ubuntu STEP 1 : type create_tables.sql phpmyadmin and select the github link STEP 2 : Download the create_tables.sql file STEP 3 : Import it on your phpmyadmin using import button on navbar, upload the file. CHEERS!! Work is Done!!

For Window User >> Just go to localhost phpmyadmin and just click this button.session_clear