MySQL Starts, but quits immediately

MySQL Starts, but quits immediately

Post by Bill Leona » Sun, 04 Aug 2002 10:40:46



Here's the console report... Anyone have any idea what might be the cause? I
checked and the .sock file exists, and of course there is no mysqld service
running (because it can't start!)

Any pointers would be greatly appreciated...!

2002-08-02 21:02:55.755 MySQLInfoTool[1464] attempting to start server
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists!
2002-08-02 21:02:55.980 MySQLInfoTool[1464] path:/usr/bin/safe_mysqld
args <CFArray 0x1ac200 [0xa01403fc]>{type = immutable, count = 1,
values = (
    0 : <CFString 0x54280 [0xa01403fc]>{contents = "--user=mysql"}
)}
Env (null)

--

www.machinemen.com                                            407.464.0147

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

MySQL Starts, but quits immediately

Post by Michael Johns » Sun, 04 Aug 2002 10:53:07


You need the mysql daemon running before you can connect to it. To me it
looks like need to start the daemon as a user with the right permissions
and then connect to it.

Is mysql configured at all on your box? If you haven't read the docs--you
probably should.

-mj


> Here's the console report... Anyone have any idea what might be the cause? I
> checked and the .sock file exists, and of course there is no mysqld service
> running (because it can't start!)

> Any pointers would be greatly appreciated...!

> 2002-08-02 21:02:55.755 MySQLInfoTool[1464] attempting to start server
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (61)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> exists!
> 2002-08-02 21:02:55.980 MySQLInfoTool[1464] path:/usr/bin/safe_mysqld
> args <CFArray 0x1ac200 [0xa01403fc]>{type = immutable, count = 1,
> values = (
>     0 : <CFString 0x54280 [0xa01403fc]>{contents = "--user=mysql"}
> )}
> Env (null)

> --

> www.machinemen.com                                            407.464.0147

> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)



> 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)



Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 
 
 

1. demon quits immediately...

 >Description:

mysqld daemon with databases from
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data/tomsEmachine.pid
051024 18:36:32  mysqld ended

 >Submitter-Id:    airdrummer
 >Originator:    tom wible
 >Organization:
 >MySQL support: none
 >Synopsis:    demon quits immediately
 >Severity:   critical
 >Priority:    <[ low | medium | high ] (one line)>
 >Category:    mysql
 >Class:    sw-bug
 >Release:    mysql-5.0.15-standard (MySQL Community Edition - Standard
(GPL))

 >C compiler:    gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
 >C++ compiler:  gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
 >Environment:
    <machine, os, target, libraries (multiple lines)>
System: Linux tomsEmachine 2.6.11-1.1369_FC4 #1 Thu Jun 2 22:55:56 EDT
2005 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using built-in specs.
Target: i386-redhat-linux
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--enable-checking=release --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-libgcj-multifile
--enable-languages=c,c++,objc,java,f95,ada --enable-java-awt=gtk
--with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
--host=i386-redhat-linux
Thread model: posix
gcc version 4.0.0 20050519 (Red Hat 4.0.0-8)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  
LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx  1 root root 13 Jun 19 21:47 /lib/libc.so.6 -> libc-2.3.5.so
-rwxr-xr-x  1 root root 1489572 May 30 08:05 /lib/libc-2.3.5.so
-rw-r--r--  1 root root 2523698 May 30 08:44 /usr/lib/libc.a
-rw-r--r--  1 root root 238 May 30 07:10 /usr/lib/libc.so
lrwxrwxrwx  1 root root 10 Jun 19 23:31 /usr/lib/libc-client.a -> c-client.a
lrwxrwxrwx  1 root root 16 Jun 19 23:31 /usr/lib/libc-client.so ->
libc-client.so.0
-rwxr-xr-x  1 root root 773464 Mar  2  2005 /usr/lib/libc-client.so.0
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data'
'--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community
Edition - Standard (GPL)' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client'
'--enable-local-infile' '--enable-assembler' '--disable-shared'
'--with-big-tables' '--with-readline' '--with-archive-storage-engine'
'--with-innodb' 'CC=gcc' 'CXX=gcc'

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

2. nfs CDROM disappears after diskchange

3. Administrative Templates upgrade

4. problem mysql deamon start and end immediately

5. Sol 2.4 - dial up PPP setup

6. MySQL Server starting then immediately stopping.

7. Money 98 forecast tax

8. MySQL stops immediately after starting

9. Ynt: Plase Let us know if there is a Racialism for Mysql product and quit

10. MySql - quit !

11. MySQL quitting, restarts only after hard reboot

12. killing mysql session if the client CGI program quits.