make sure mysql owns the database directory and all its files.
silvio@stripped wrote:
>>Description:
>>
>Empty table returned when qureying for "show databases;" right
>after installation. It shows a table with 10 rows, with empty fields in
>each, and writes in the total, 11 databases.
>When using a newly created database, doesn't show created tables (on show tables),
>what can be the problem ?
>
>>How-To-Repeat:
>>
>Just compile...maybe the configuration will help.
>
>>Synopsis:
>>Severity: critical
>>Priority: high
>>Category: mysql
>>Class: sw-bug
>>Release: mysql-3.23.47 (Source distribution)
>>Server: lt-mysqladmin Ver 8.23 Distrib 3.23.47, for pc-linux-gnu on i586
>>
>Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>and you are welcome to modify and redistribute it under the GPL license
>
>Server version 3.23.47-log
>Protocol version 10
>Connection Localhost via UNIX socket
>UNIX socket /tmp/mysql.sock
>Uptime: 6 min 36 sec
>
>Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
> Queries per second avg: 0.013
>
>>Environment:
>>
>
>System: Linux home.pashkovsky.com 2.2.19 #7 Tue Oct 16 00:24:21 IST 2001 i586 unknown
>Architecture: i586
>
>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-pc-linux-gnu/2.95.3/specs
>gcc version 2.95.3 20010315 (release)
>Compilation info: CC='gcc' CFLAGS='-O3 -march=i586 -mcpu=i586 -felide-constructors
> -fno-exceptions -fomit-frame-pointer -fno-rtti' CXX='c++' CXXFLAGS='' LDFLAGS=''
>LIBC:
>lrwxrwxrwx 1 root root 13 Nov 16 14:45 /lib/libc.so.6 ->
> libc-2.2.4.so
>-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
>-rwxr-xr-x 1 root root 5724399 Oct 3 20:55 /lib/libc-2.2.4.so
>-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
>-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
>Configure command: ./configure
>Perl: This is perl, version 5.005_03 built for i386-linux
>
>---------------------------------------------------------------------
>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 <mysql-thread95740@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
