I have had the same problem on a Redhat 7.0 box w/2.4.1 kernel with
mysql versions 3.23.32 thru 3.23.37
The tables and databases are there and are usable, but 'show databases'
and 'show tables' return nothing. We've installed this version on
another machine and it works fine. Must be a library thing?
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i686-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS=' -O3' CXX='egcs' CXXFLAGS=' -O3
-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Jan 26 03:44 /lib/libc.so.6
-> libc-2.2.so
-rwxr-xr-x 1 root root 5072386 Jan 10 18:37 /lib/libc-2.2.so
-rw-r--r-- 1 root root 24498288 Jan 10 18:35 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 10 18:35 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jan 26 03:47
/usr/lib/libc-client.a -> c-client.a
Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--without-berkeley-db --without-innodb --enable-assembler
--with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
[EMAIL PROTECTED] wrote:
>> Description:
>
> empty show tables
>
>> How-To-Repeat:
>
> show tables;
>
>
>> Submitter-Id: <submitter ID>
>> Originator: [EMAIL PROTECTED]
>> Organization:
>
> poelzi.org
>
>> MySQL support: none
>> Synopsis: show tables return nothing. show databases too.
>> Severity: serious
>> Priority: high
>> Category: mysql
>> Class: sw-bug
>> Release: mysql-3.23.37
>
>
>> Environment:
>
>
> System: Linux cinis.poelzi.org 2.4.3 #5 Wed Apr 18 23:12:52 CEST 2001 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> -rw-r--r-- 1 root root 24419620 Apr 18 19:42 /lib/libc.a
> -rw-r--r-- 1 root root 176 Apr 18 19:42 /lib/libc.so
> lrwxrwxrwx 1 root root 13 Apr 19 08:22 /lib/libc.so.6 ->
>libc-2.2.2.so
> -rwxr-xr-x 1 root root 5195054 Dec 15 1999 /lib/libc-2.1.2.so
> -rwxr-xr-x 1 root root 4903193 Apr 18 19:47 /lib/libc-2.2.2.so
> -rw-r--r-- 1 root root 20508346 Dec 15 1999 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Dec 15 1999 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Daniel Bohling
NewsFactor Network
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php