Gerald Clark wrote:
> Perhaps mysql does not own the directory that contains the databases.
>
> > I just compiled from scratch, and successfully installed v3.23.42 on an
> > RH7.1 system. EVerything went fine, no errors anywhere, it started up
> > fine and I was able to set passwords fine. Then I try to log in and
> > execute 'show databases;' and it just sits there:
> >
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 6 to server version: 3.23.42-log
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> show databases;
> >
> >
> > And that's it. Nothing happens. I have to hit CTRL-C to get out.
> > Looking in the log file, it doesn't tell me anything aside from logging
> > the commands, no errors.
> >
> > If I use a database, I can display its tables just fine, so I know the
> > 'show' command by itself works. But why can't I see databases now?
Problem is, it does:
ls -l /usr/local/var/mysql
d-wx-----x 3 sql daemon 4096 Sep 21 14:33 ./
drwx--x--x 3 root root 4096 Sep 19 14:30 ../
-rw-r--r-- 1 sql daemon 553 Sep 21 14:33 gems.err
-rw-rw---- 1 sql daemon 1748 Oct 4 15:01 gems.log
-rw-rw---- 1 sql daemon 3 Sep 21 14:33 gems.pid
drwx------ 2 sql daemon 4096 Oct 4 14:25 mysql/
srwxrwxrwx 1 sql daemon 0 Sep 21 14:33 mysql.sock=
--
W | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
---------------------------------------------------------------------
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
