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

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

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

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

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