1146 - Table phpmyadmin pma recent doesn t exist

Question

Solution Guys     FYI i am using xampp to use phpmyadmin  and this error happens during the process of creating a database on localhost  Below is the code for config inc file under phpmyadmin directory     lt  php       This is needed for cookie based authentication to encrypt password in    cookie      cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE      AUTH            Servers configuration      i   0         First server      i        Authentication type and info     cfg  Servers    i   auth type      HTTP    cfg  Servers    i   user      root     cfg  Servers    i   password      password    cfg  Servers    i   extension      mysql    cfg  Servers    i   AllowNoPassword     true   cfg  Lang             Bind to the localhost ipv4 address and tcp     cfg  Servers    i   host      localhost    cfg  Servers    i   connect type      tcp       User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma bookmark    cfg  Servers    i   relation      pma relation    cfg  Servers    i   table info      pma table info    cfg  Servers    i   table coords      pma table coords    cfg  Servers    i   pdf pages      pma pdf pages    cfg  Servers    i   column info      pma column info    cfg  Servers    i   history      pma history    cfg  Servers    i   designer coords      pma designer coords      cfg  Servers    i   tracking      pma tracking      cfg  Servers    i   userconfig      pma userconfig      cfg  Servers    i   recent      pma recent      cfg  Servers    i   table uiprefs      pma table uiprefs          End of servers configuration        gt

User · Answer

The simpliest way is to drop database phpmyadmin and run sql create tables sql script  Just login to mysql console and   DROP DATABASE phpmyadmin      your path to pma  sql reate tables sql

User · Answer

You have to run the create tables sql inside the examples  folder on phpMyAdmin to create the tables needed for the advanced features  That or disable those features by commenting them on the config file      usr share doc phpmyadmin examples    Only to complete de choosed answer  this is the path to the examples  directory on Ubuntu   Just use the import feature and choose  create tables sql gz

User · Answer

I also have same problem   I tried everything solution in google  but still error   But  now i resolved it   I ve resolved with make give double slash like that      cfg  Servers   1   table uiprefs      pma  table uiprefs     It works

User · Answer

You can also find create tables sql file it phpMyAdmin s repo  Just import it from phpMyAdmin panel  It should work

User · Answer

Edit    cfg  Servers    i   userconfig      pma  userconfig      Change into    Cfg   Servers      i    table uiprefs        pma table uiprefs       Then https   kamalkaur188 wordpress com category removing-error-1146-table-phpmyadmin-pma recent-doesnt-exist  work for me

User · Answer

I shear the point made by user2237829  The table names in the create tables script used a double underscore while the table names in the xampp example uses a single underscore

User · Answer

I encountered the same problem but none of your answers solved it  But I found this link  I had to edit  etc phpmyadmin config inc php    cfg  Servers    i   table uiprefs      pma table uiprefs     into   cfg  Servers    i   pma  table uiprefs        pma  table uiprefs       My problem was solved  hope it can help others

User · Answer

This one just worked for me      The error message displayed is        1146     Table    phpmyadmin pma table uiprefs    doesn   t exist      on your programme files locate the configuration file config inc php phpmyadmin  Then trace the file  Cfg   Servers      i    table uiprefs        pma table uiprefs      and replace it to the code    cfg   Servers      i    pma  table uiprefs        pma  table uiprefs      restart your XAMMP and start localhost  solved

User · Answer

After I downloaded phpmyadmin from their website  I extracted the create tables sql file from the examples folder and then I imported it from the  Import  tab of phpmyadmin  It creates the database  phpmyadmin  and the relevant table within   This step might not be needed as the 12 tables were already there    The problem seemed to be the double underscore in the tables  names   I edited  config inc php  and added another underscore      after the  pma   prefix of the tables   ie    cfg  Servers    i   userconfig      pma userconfig     became   cfg  Servers    i   userconfig      pma  userconfig     This solved the issue for me

User · Answer

You will find create tables sql gz file in  usr share doc phpmyadmin examples  dir    Extract it and  change pma  prefix by pma   or vice versa    Then import you new script SQL

User · Answer

This is a known bug on Linux Debian  I solved using the create tables sql in the official package and changing pma  with pma   inside  etc phpmyadmin config inc php

User · Answer

i ve resolved with  sudo dpkg-reconfigure phpmyadmin

User · Answer

Run   sudo dpkg-reconfigure phpmyadmin   in your unix linux Mac console

User · Answer

You can solve it just in 1 second   just use this url   http   127 0 0 1 phpmyadmin    instead of  http   localhost phpmyadmin

User · Answer

I commented out the line with the following setting   cfg  Servers   1   table uiprefs      Its not really an elegant solution  but it worked for my needs   Just getting a basic PMA for running queries etc without UI customization    Please do this only if you do not care about UI Prefs  If not  other people have answered this question very well

User · Answer

Just to complete the answer - on Ubuntu Mint you can just run   zcat  usr share doc phpmyadmin examples create tables sql gz   mysql    of course this assumes development environment where your default mysql user is root and you use no password  in other case use   mysql -uuser name -p

User · Answer

You have to run the create tables sql inside the examples  folder on phpMyAdmin to create the tables needed for the advanced features  That or disable those features by commenting them on the config file

[mysql] #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

Examples related to mysql

Examples related to database

Examples related to phpmyadmin