Results 1 to 8 of 8

Thread: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

  1. #1
    Join Date
    Nov 2012
    Location
    Great Britain
    Beans
    80

    error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    this morning I loaded up phpMyAdmin after not using it for over a week, and was greeted by the message:

    SELECT `tables`
    FROM `phpmyadmin`.`pma_recent`
    WHERE `username` = 'root'

    MySQL said:

    #1146 - Table 'phpmyadmin.pma_recent' doesn't exist
    I can't see a database with the name "phpMyAdmin or anything similar" on either this server with the error
    or with either of my other servers that aren't outputting any errors; also it seems that whatever is causing the error isn't impeding the programs that use MySQL;
    I can't find anything on Google that seems relevant, and I've rebooted the machine and I still get this message as soon as I log into phpMyAdmin...
    Can anyone shed any light on what could be causing this problem, or how to clean it up?

    Thanks

  2. #2
    Join Date
    Nov 2012
    Location
    Great Britain
    Beans
    80

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    I've still not figured it out, or found any useful information on Google, has anyone else encountered this before?

  3. #3
    Join Date
    Nov 2012
    Location
    Great Britain
    Beans
    80

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    if anyone else has this problem, use phpMyAdmin to import "create_tables.sql" from the examples folder of phpMyAdmin

  4. #4
    Join Date
    Apr 2013
    Beans
    1

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    Toriku, thanks so much for the tip! worked like a charm and you've saved me hours of work and searching...

  5. #5
    Join Date
    Apr 2008
    Location
    Vancouver
    Beans
    21
    Distro
    Ubuntu 9.04 Jaunty Jackalope

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    Quote Originally Posted by Toriku View Post
    if anyone else has this problem, use phpMyAdmin to import "create_tables.sql" from the examples folder of phpMyAdmin
    helpful - but you omitted the path, which is more useful if you arrived here via Google and don't know where that is, exactly:

    /usr/share/doc/phpmyadmin/examples/

    Just use the import feature and choose "create_tables.sql.gz".

    For more info, see:
    http://wiki.phpmyadmin.net/pma/Configuration_storage

  6. #6
    Join Date
    Jun 2013
    Beans
    1

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    Quote Originally Posted by Toriku View Post
    if anyone else has this problem, use phpMyAdmin to import "create_tables.sql" from the examples folder of phpMyAdmin
    : D muchas gracias compañero
    solo me registre en el foro para agradecer tu ayuda

  7. #7
    Join Date
    Jun 2013
    Beans
    1

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    Just as an FYI, anyone looking for a quick solution, when viewing the config-db.php file in etc/phpmyadmin, note that the dbname variable is the name of the table that the create_tables.sql file generated. This will allow you to resume use of PMA without any issues.

  8. #8
    Join Date
    Aug 2013
    Beans
    1

    Re: error #1146 - Table 'phpmyadmin.pma_recent' doesn't exist

    Quote Originally Posted by SynthesizersFTW View Post
    helpful - but you omitted the path, which is more useful if you arrived here via Google and don't know where that is, exactly:

    /usr/share/doc/phpmyadmin/examples/

    Just use the import feature and choose "create_tables.sql.gz".

    For more info, see:
    http://wiki.phpmyadmin.net/pma/Configuration_storage
    Thank you so much this helped me solve my issue. It appears my whole Lamp Server configuration failed.
    After I completed the steps above, I also received another error where at the bottom of the page I was getting read error message with
    Connection for controluser as defined in your configuration failed.

    I had to basically uninstall and re-intall phpmyadmin
    PHP Code:
    sudo apt-get remove phpmyadmin
    sudo apt
    -get install phpmyadmin 
    Details can be found here http://ubuntuforums.org/showthread.php?t=1152326&page=2

    All seems to working fine now

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •