PHPmyAdmin "No tables found in database."

mySQL command line gives correct result.

[itKiwi]

I wasn't sure whether to put this here or in "databases".

I have been using phpmyadmin, and mysql, with Apache on WindowsXP for the past couple of months. Recently, I reorganised (replaced) my hard disk, and at the same time,upgraded PHP and MySQL. Now, using PHPmyAdmin, I get the message "No tables found in database." on **some** of the databases I have been working with, but not all. Using the mySQL command line, everything is OK !

I am also getting "Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.32. This may cause unpredictable behavior." when I logon to phpMyAdmin. Is this part of the problem ?

Where is/are my problems ?
How do I go about solving it/them ?

Thanks.

[inveni0]

Try upgrading your PHP MySQL Library to see what that does. Chances are it's doesn't offer all of the calls that the server is making, which might cause some tables to fail and not others.

Export all of your tables and then do a completely new install of MySQL and phpMyAdmin.

[itKiwi]

I upgraded PHP to 5.2.9. Shouldn't this give me the latest MySQL library ?
Thanks.

[coopster]

MySQL is bundled separately than PHP. When you upgrade versions (MySQL 5.0 to 5.1) you must watch for any patches to apply. MySQL actually has an upgrade patch and this is likely your issue. Read and apply ...

Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to add new privileges or support new features. When you update to a new version of MySQL, you should update your system tables as well to make sure that their structure is up to date

Old Resource: mysql_fix_privilege_tables — Upgrade MySQL System Tables [dev.mysql.com]

Latest resource: mysql_upgrade — Check Tables for MySQL Upgrade [dev.mysql.com]

[itKiwi]

Thanks guys. I'll do as you suggest, though it won't be for a few days.
Thanks again.

[Lazlo]

Goog : Your PHP MySQL library version 5.0.51a ....

wampserver phorum read.php?2,49927

it's php bug and has no effect, so just ignore it ;-)

[coopster]

There is but one single response in that WAMP forum post with zero explanation or resource. I am quite certain that is incorrect information as this does not appear to be a PHP bug. Run the mysql_upgrade as recommended earlier.