Ashley M. Kirchner writes: > 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= <cut>
Hello, Have you compiled your MySQL with the gcc that comes with RH 7.1 by default, gcc 2.96 ? If so, please remove the whole MySQL installation, uninstall the gcc 2.96 and install 2.95.2 / 2.95.3 and compile again. Don't even compile the gcc 2.95.2 with 2.96, but be on the safe side and install an rpm, can be done even from a SuSE distribution. Make sure you uninstall first all 2.96 related dists. You can find them with rpm -q -a | grep 2.96 gcc 2.96 on Redhat is broken and cannot be used to compile a functioning binary of MySQL. Another option is to download a binary from our site. Regards, - Jani For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
