4 messages in com.mysql.lists.mysql-deRe: Can't connect to local MySQL serv...
FromSent OnAttachments
Thomas Goik01 Dec 2004 15:39 
Sebastian Mendel02 Dec 2004 02:48 
Marcus Franke02 Dec 2004 03:00 
Sebastian Mendel02 Dec 2004 04:01 
Subject:Re: Can't connect to local MySQL server through socket
From:Sebastian Mendel (lis@sebastianmendel.de)
Date:12/02/2004 02:48:13 AM
List:com.mysql.lists.mysql-de

Thomas Goik wrote:

Hallo,

nach einem Update unseres Servers

./configure --prefix=/usr/ --enable-assembler --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --sysconfdir=/etc/mysql/ --localstatedir=/var /usr/src/mysql-4.1.7/make /usr/src/mysql-4.1.7/make install

Jetzt läuft er Server zwar noch, aber bei einem /etc/init.d/mysql restart Gibt er folgenden Fehler aus!

/var/log/mysql/mysql.err: 041202 00:25:29 Error at /etc/init.d/mysql\n/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

s-esl4:~# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

s-esl4:~# ps xa | grep mysqld 14861 ? S 0:00 /bin/sh /usr/bin/mysqld_safe 14897 ? S 1:23 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock 14898 ? S 1:37 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock 14899 ? S 11:53 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock 8710 ? R 0:00 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock 8711 ? R 0:00 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock 8712 ? R 0:00 /usr//libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock

was gibt denn ein

$ ll /var/run/mysqld/mysqld.sock

aus?

oder ein

$ locate mysql.sock

bei mir liegt der hier:

srwxrwxrwx 1 mysql mysql 0 1. Dez 16:09 /var/lib/mysql/mysql.sock

www.sebastianmendel.de www.warzonez.de www.tekkno4u.de www.nofetish.com www.sf.net/projects/phpdatetime www.sf.net/projects/phptimesheet