MySQL error - 1932 - Table phpmyadmin pma user config doesn t exist in engine

Question

I am trying to set up my database in MySQL using XAMPP  I am doing this via phpMyAdmin on localhost Apache is running   The only action on my part is typing in a new  unused  name for a database  click create and     this error occurs   Error SQL query  DocumentationEdit Edit   SELECT MAX version  FROM  phpmyadmin   pma  tracking  WHERE  db name     stuff tessss   AND  table name        AND FIND IN SET  CREATE DATABASE  tracking   gt  0 MySQL said  Documentation        1932 - Table  phpmyadmin pma  tracking  doesn t exist in engine  The database is showing in the list of databases  If you were to click on one  it takes forever and a day to not load   I ve tried researching and implementing the other 1932 error solutions on stack and other places but to no avail   Here are the following versions for the tech I am utilizing     OS X El Capitan - 10 11 1  Server version  Apache 2 4 16  Unix  PHP 5 6 15  i had to reinstall with -intl extensions because CakePHP was complaining about a dependency  CakePHP 3 0  this required installation of Composer to utilize cakePHP from command line  which I believe runs off of PHP  mySQL  Ver 14 14 Distrib 5 7 9  for osx10 11  x86 64  XAMPP 5 6 14-4   I ve read all sorts of solutions such as run it in Linux  or using an older version of XAMPP  etc  I figured there is a smarter person out there who might know the solution  I mainly had a hard time trying to figure out where to research  as well   If anyone who could point me in the right direction I would greatly appreciate it

User · Answer

you need to download the previous version  xampp actually present bug in its latest version   Good Luck

User · Answer

if someone is still facing this issue  for me it started to occur after I changed my mysql data with mysql backup earlier to solve another issue  I tried a lot of methods  and finally found the solution was very simple  Just click on this icon Reset session  after opening PhPMyAdmin it was loading in my case  just below the logo of PhPMyAdmin  It fixed the issue in one-click  For me  the error code was  1142 PhpMyAdmin Reset Session

User · Answer

Had the same problem in Ubuntu 14 using XAMPP  Here s what I did which worked     Stop mysql if its running in xampp vi  opt lamp phpmyadmin config inc php  use sudo if you are not the su  replace    cfg  Servers   1   relation      pma  relation    cfg  Servers   1   userconfig      pma  userconfig    cfg  Servers   1   table info      pma  table info         to    cfg  Servers   1   pma  relation      pma  relation    cfg  Servers   1   pma  userconfig      pma  userconfig    cfg  Servers   1   pma  table info      pma  table info         basically add pma   prefix to the left side similar to the right   Run mysql and access localhost phpmyadmin and click on a db to check if it works     Hope this helps

User · Answer

In short just replace the content of config inc php from line 50-69 with       cfg  Servers    i   pma  bookmark      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  table uiprefs      pma  history     cfg  Servers    i   pma  table uiprefs      pma  table uiprefs     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  users      pma  users     cfg  Servers    i   pma  usergroups      pma  usergroups     cfg  Servers    i   pma  navigationhiding      pma  navigationhiding     cfg  Servers    i   pma  savedsearches      pma  savedsearches     cfg  Servers    i   pma  central columns      pma  central columns     cfg  Servers    i   pma  designer coords      pma  designer coords     cfg  Servers    i   pma  designer settings      pma  designer settings     cfg  Servers    i   pma  export templates      pma  export templates     cfg  Servers    i   pma  favorite      pma  favorite

User · Answer

ErrorCode   1932 Worked for me on Ubuntu 14 04 Trusty   cfg  Servers    i   pma  bookmark      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  table uiprefs      pma  history    cfg  Servers    i   pma  table uiprefs      pma  table uiprefs    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  users      pma  users    cfg  Servers    i   pma  usergroups      pma  usergroups    cfg  Servers    i   pma  navigationhiding      pma  navigationhiding    cfg  Servers    i   pma  savedsearches      pma  savedsearches    cfg  Servers    i   pma  central columns      pma  central columns    cfg  Servers    i   pma  designer coords      pma  designer coords    cfg  Servers    i   pma  designer settings      pma  designer settings       cfg  Servers    i   pma  export templates      pma  export templates    cfg  Servers    i   pma  favorite      pma  favorite

User · Answer

If all the solutions above don t work  try to    Add  i   1  after    Servers configuration      in place of  i   0 in your phpmyadmin config inc php  file  Running XAMPP on local windows server  my mysql data files are not under the usual install path  C  Xampp   but on another disk   So now I have the phpmyadmin tables with the double    like pma  table    and  i   1

User · Answer

Finally  I find the solution  We can find there really exists the table  pma  tracking  when we expand the phpmyadmin database   But the system error call on  1932 - Table  phpmyadmin pma  tracking  doesn t exist in engine  So just try to remove the old pma    database first and reconfig them later  1 Remove the wrong tables in xampp s installation path and remove all the files in var mysql phpmyadmin   which are similar like pma  bookmark frm pma  bookmark ibd    2 Reinstall the sql of phpmyadmin  which located in phpmyadmin sql   something like  create tables sql   run them with mysql  lt  create table sql  etc  Then it works

User · Answer

This is due to sometimes the session query may have invalid characters  try clicking on the highlighted icons in PHPMYADMIN  and it will be resolved  because session values resetted to defaults See Image

User · Answer

make change in changes in  opt lampp phpmyadmin config inc php       lt  php        vim  set expandtab sw 4 ts 4 sts 4                    phpMyAdmin sample configuration  you can use it as base for        manual configuration  For easier setup you can use setup                All directives are explained in documentation in the doc  folder        or at  lt http   docs phpmyadmin net  gt                  package PhpMyAdmin                         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         cfg  Servers    i   auth type      config        cfg  Servers    i   user      root        cfg  Servers    i   password                Server parameters           cfg  Servers    i   host      localhost          cfg  Servers    i   connect type      tcp        cfg  Servers    i   compress     false       cfg  Servers    i   AllowNoPassword     true                  phpMyAdmin configuration storage settings                  User used to manipulate with storage            cfg  Servers    i   controlhost                 cfg  Servers    i   controlport                 cfg  Servers   1   pmadb      phpmyadmin        cfg  Servers   1   controluser      pma        cfg  Servers   1   controlpass               cfg  Servers   1   bookmarktable      pma bookmark        cfg  Servers   1   relation      pma relation        cfg  Servers   1   userconfig      pma userconfig        cfg  Servers   1   table info      pma table info        cfg  Servers   1   column info      pma column info        cfg  Servers   1   history      pma history        cfg  Servers   1   recent      pma recent        cfg  Servers   1   table uiprefs      pma table uiprefs        cfg  Servers   1   tracking      pma tracking        cfg  Servers   1   table coords      pma table coords        cfg  Servers   1   pdf pages      pma pdf pages        cfg  Servers   1   designer coords      pma designer coords              cfg  Servers    i   favorite      pma  favorite           cfg  Servers    i   users      pma  users           cfg  Servers    i   usergroups      pma  usergroups           cfg  Servers    i   navigationhiding      pma  navigationhiding           cfg  Servers    i   savedsearches      pma  savedsearches           cfg  Servers    i   central columns      pma  central columns           cfg  Servers    i   designer settings      pma  designer settings           cfg  Servers    i   export templates      pma  export templates          Contrib   Swekey authentication            cfg  Servers    i   auth swekey config       etc swekey-pma conf                   End of servers configuration                         Directories for saving loading files from server              cfg  UploadDir              cfg  SaveDir                         Whether to display icons or text or both icons and text in table row        action segment  Value can be either of  icons    text  or  both          default    both                 cfg  RowActionType      icons                   Defines whether a user should be displayed a  show all  records          button in browse mode or not         default   false                cfg  ShowAll     true                  Number of rows displayed when browsing a result set  If the result        set contains more rows   Previous  and  Next          Possible values  25  50  100  250  500        default   25                cfg  MaxRows     50                  Disallow editing of binary fields        valid values are           false    allow editing           blob    allow editing except for BLOB fields           noblob  disallow editing except for BLOB fields           all     disallow editing        default    blob                 cfg  ProtectBinary     false                  Default language to use  if not browser-defined or user-defined         you find all languages in the locale folder         uncomment the desired line         default    en                 cfg  DefaultLang      en          cfg  DefaultLang      de                   How many columns should be used for table display of a database          a value larger than 1 results in some information being hidden         default   1                cfg  PropertiesNumColumns     2                  Set to true if you want DB-based query history If false  this utilizes        JS-routines to display query history  lost by window close                This requires configuration storage enabled  see above         default   false                cfg  QueryHistoryDB     true                  When using DB-based query history  how many entries should be kept         default   25                cfg  QueryHistoryMax     100                  Whether or not to query the user before sending the error report to        the phpMyAdmin team when a JavaScript error occurs               Available options          ask     always     never          default    ask                 cfg  SendErrorReports      always                   You can find more configuration options in the documentation        in the doc  folder or at  lt http   docs phpmyadmin net  gt

User · Answer

I ve encountered the same problem in OSX  I ve tried to replace the things like  cfg  Servers    i   usergroups   to   cfg  Servers    i   pma  usergroups        It works in safari but still fails in chrome  But the so called  work  in safari can get the message that the features which have been modified are not in effect at all  However  the  work  means that I can access the dbs listed left  I think this problem maybe a bug in the new version of XAMPP  since the  1932 problems in google is new and boomed  You can have a try at an older version of XAMPP instead until the bug is solved  http   sourceforge net projects xampp files XAMPP 20Linux 5 6 12  Hope it can help you

User · Answer

I had the same error and it occured when changing the mysql data folder to another folder  I just copied all folders inside mysql data folder to a new location except for  two files   Those are ib logfile0 and ib logfile1  those are automatically created when starting the MySQL server  That worked for me

User · Answer

This is my experience for this problem maybe it could help you    I copied all folders and files inside the  data folder to have a backup from my db    When I switched to another Computer s Xampp and I started copying all folders and files copied before from previous phpmyadmin  data folder    So when I was done this problem happened for me     To solve this issue     1 - I made a backup from  data folder of phpmyadmin by copying only only folders have same name with tables I want to make backup     2 -  Uninstall Xampp   3 - Reinstall Xampp    4 - Copy all folders Kept in step 1 inside mysql data folder   this folders are only database tables and be careful don t touch another file and folder or replace anything when copying

User · Answer

This is how i solved my problem  go to xampp mysql data directory delete all the unwanted files except database folders restart the xampp server and go to the dashboard click the clear session data icon below the phpmyadmin icon

[mysql] MySQL error - #1932 - Table 'phpmyadmin.pma user config' doesn't exist in engine

Examples related to mysql

Examples related to apache

Examples related to phpmyadmin

Examples related to xampp