show database does not work ;-(

2001-02-16 Thread Greg Cope 

Dear All

I've just installed mysql on a new host (3.23.33) and show databases
does not work ;-(.

The data directory is thus:

drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql

Inside it has:

[root@server1 lib]# ls -l mysql/
total 28
drwx--S---2 mysqlmysql4096 Feb 16 13:43 foo
drwxrwxr-x   24 mysqlmysql4096 Feb 16 13:23 mysql
-rw-rw1 mysqlmysql5769 Feb 16 14:09 server1.log
-rw-rw-r--1 mysqlmysql 780 Feb 16 14:06
server1.totallyradio.com.err
-rw-rw1 mysqlmysql   4 Feb 16 14:06
server1.totallyradio.com.pid
drwx--2 mysqlmysql4096 Feb 16 13:23 test

Which all looks normal.

I can connect etc  but show does not work - if I do :

SELECT * on mysql.users;

I get results.

Is this a bug (in which case I do a full bug report) -- I have a feeling
I am doing something very wrong that must be obvious ?

A rather dazed and confused,

Greg

-
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

Re: show database does not work ;-(

2001-02-16 Thread Fred van Engen 

On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
 Dear All
 
 I've just installed mysql on a new host (3.23.33) and show databases
 does not work ;-(.
 

Maybe it would help to read (or search) the list before posting.

There are several mails regarding this problem, among them a mail with
subject 'Some problems encountered when linked to glibc-2.2.1'. It
suggests a fix I believe. If the fix isn't clear, please repost your
(new) question. I'm not running MySQL on Linux, but someone else will
probably be able to help implement the fix then.


Regards,

Fred.

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-
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

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope 

Rick Roberts wrote:
 
 SHOW DATABASES;

Sorry my subject line had the last S missing:

mysql 010216 15:29:14   1 Query  SHOW DATABASES
SHOW DATABASES;
+--+
| Database |
+--+
|  |
|  |
|  |
|  |
| test |
+--+
5 rows in set (0.01 sec)

Are you using 3.23.33 ?

Greg

-
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

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope 

Fred van Engen wrote:
 
 On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
  Dear All
 
  I've just installed mysql on a new host (3.23.33) and show databases
  does not work ;-(.
 
 
 Maybe it would help to read (or search) the list before posting.

I have already searched the list, and it has not helped.

 
 There are several mails regarding this problem, among them a mail with
 subject 'Some problems encountered when linked to glibc-2.2.1'. It
 suggests a fix I believe. If the fix isn't clear, please repost your
 (new) question. I'm not running MySQL on Linux, but someone else will
 probably be able to help implement the fix then.

I'm on glibc-2.1.3

I've narrowed this down to a difference between the mysqld binary.  I
just tried it on two near identical machines and there appears to be a
bug bug.

3.23.32 works as expected - 3.23.33 does not - here at least.

Greg

 
 Regards,
 
 Fred.
 
 --
 Fred van Engen  XO Communications B.V.
 email: [EMAIL PROTECTED] Televisieweg 2
 tel: +31 36 5462400 1322 AC  Almere
 fax: +31 36 5462424 The Netherlands
 
 -
 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

-
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

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope 

Rick Roberts wrote:
 
 mysql select version();
 +---+
 | version() |
 +---+
 | 3.23.33   |
 +---+
 1 row in set (0.01 sec)
 
 mysql SHOW DATABASES;
 +--+
 | Database |
 +--+
 | mysql|
 | test |
 +--+
 2 rows in set (0.02 sec)
 
 I'm using Mandrake 7.2.
 I installed using the RPM
 MySQL-3.23.33-1.i386.rpm

Thanks


Not much help to me mind ...

Thanks again ;-(

Greg

-
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