Check permissions.
The var directory anad all subdirectories and files must
be accessible by the user under which MySQL runs.
The directory containing the mysql.lock file must be readable and
searchable by everyone.
Drew Degentesh wrote:
>
> >Description:
> mysql hangs. This is really frustrating. History:
> -had 3.23.27 running. Had to restart the machine.
> -on reboot, no clients would connect (command line , Perl or PHP)
> -tried to restart by rc.d/initd/mysql stop, that timed out
> -killed off processes with kill -9
> -tried to restart, clients still hanging
> -downlaoded 3.23.32 binary. hung up in mysql_install_db after printing "installing
>all prepared tables"
> -killed those processes off..s.tarted with safe_mysqld ... &
> -clients still hung
> -downloaded 3.23.32 source. compiled, hung up in mysql_install_db after printing
>"installing all prepared tables"
> -killed off those processes ,started with safe_mysqld ... &, clients still hung
> -ran myisamchk and isamchk on all DB files.. still hangs
> -removed all my.cnf's ... still hangs
>
> Im SUPER FRUSTRATED...please help!!!
>
> >How-To-Repeat:
>
> >Fix:
>
>
> >Submitter-Id: <submitter ID>
> >Originator: Drew Degentesh
> >Organization:
> >MySQL support: none
> >Synopsis: mysql clients hung (cannot start)
> >Severity: critical
> >Priority: high
> >Category: mysql
> >Class:
> >Release: mysql-3.23.27-beta (Official MySQL binary)
>
> >Environment:
>
> System: Linux 2.2.12-20RS #1 Mon Feb 14 16:39:25 CST 2000 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/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc'
>CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static'
> LIBC:
> lrwxrwxrwx 1 root root 13 Mar 30 2000 /lib/libc.so.6 ->
>libc-2.1.2.so
> -rwxr-xr-x 1 root root 4118683 Feb 23 2000 /lib/libc-2.1.2.so
> -rw-r--r-- 1 root root 20031726 Feb 23 2000 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Feb 23 2000 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
>MySQL binary' --with-extra-charsets=complex --enable-assembler
>--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
>
> ---------------------------------------------------------------------
> 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
