PhpMyAdmin shows no tables, although they do exist

Posted on 2006-03-26
Last Modified: 2013-12-12
Hi There,

I have recently setup PHP, MySQL and phpMyAdmin on a 2003 server for development work.  After some initial problems, I have (or thought I had) everything working.

I started to set up my database using phpMyAdmin.  I created my first table and everything appeared to work ok, but under my database phpMyAdmin reports "No Tables found"

If I try to re-create the table, an error message says that MySql reports "The table already exists"

Any ideas on why I can't see the table in phpMyAdmin?

Question by:jfrent
    LVL 17

    Expert Comment

    Hi jfrent,

    Make sure that you are connected to the correct database in phpMyAdmin.

    Joe P
    LVL 2

    Author Comment

    I select the database from the left-side dropdown and it says "No tables..."

    Is that what you mean?
    LVL 2

    Expert Comment

    did you set the configuration correctly in the config file !?
    LVL 2

    Accepted Solution

    also this might seem like a similar problem

    This seems to be a PWS bug. Filippo Simoncini found a workaround (at this time there is no better fix): remove or comment the DOCTYPE  declarations (2 lines) from the scripts libraries/, libraries/, index.php, left.php and libraries/common.lib.php.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    This is a general how to create your own custom plugin system for your PHP application that you designed (or wish to extend a third party program to have plugin functionality that doesn't have it yet).  This is not how to make plugins for existing s…
    The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now