phpmyadmin pma table uiprefs doesn t exist

Question

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

User · Accepted Answer

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:

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

User · Answer

you should reconfigure the phpmyadmin On terminal    sudo dpkg-reconfigure phpmyadmin

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

For ubuntu me help  - sudo dpkg-reconfigure phpmyadmin

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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           lt  php     foreach  cfg  Servers   as  i     v           cfg  Servers    i   table uiprefs      pma  table uiprefs

User · Answer

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

User · Answer

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

User · Answer

Try  sudo dpkg-reconfigure phpmyadmin  To Replace config file  etc phpmyadmin config-db php with new version

User · Answer

I just located the create tables sql   saved to my desktop   opened phpMyAdmin   selected the import tab   selected the create tables sql  clicked ok

User · Answer

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

[mysql] phpmyadmin.pma_table_uiprefs doesn't exist

Examples related to mysql

Examples related to phpmyadmin