Thanks Mike and Sebastian,
I merged this patch which IMO fixes this problem:
Index: database_interface.lib.php =================================================================== RCS file: /cvsroot/phpmyadmin/phpMyAdmin/libraries/database_interface.lib.php,v retrieving revision 2.51 retrieving revision 2.52 diff -C2 -d -r2.51 -r2.52 *** database_interface.lib.php 22 Jun 2006 19:59:30 -0000 2.51 --- database_interface.lib.php 25 Jun 2006 12:40:29 -0000 2.52 *************** *** 298,302 **** null, $link); unset( $sql_where_table, $sql ); ! } else { foreach ( $databases as $each_database ) { if ( true === $tbl_is_group ) { --- 298,306 ---- null, $link); unset( $sql_where_table, $sql ); ! } ! // If permissions are wrong on even one database directory, ! // information_schema does not return any table info for any database ! // this is why we fall back to SHOW TABLE STATUS even for MySQL >= 50002 ! if ( PMA_MYSQL_INT_VERSION < 50002 || empty($tables)) { foreach ( $databases as $each_database ) { if ( true === $tbl_is_group ) {
Sebastian Mendel a écrit :
-------- Original-Nachricht -------- Betreff: mysql phpmyadmin problem Datum: Fri, 23 Jun 2006 23:46:23 -0400 Von: Michael mike@brenden.com An: cybot_tm@users.sourceforge.net
Hi there,
As an offshoot of mysql/phpmyadmin bug #1436171
If permissions change away from mysql.mysql on any database directory under /var/lib/mysql (to, say, root.root),
and phpmyadmin detects mysql version > 5.whatever (i.e., phpmyadmin tries to utilize information_schema),
then phpmyadmin reports No database tables found, despite there obviously being, say, dozens of databases, and hundreds of tables.
So the one permissions error on one database's directory screws up every database as far as phpmyadmin is concerned.
Thought you should know.
Best regards from outside washington, dc Michael