mysqld socket fehler

[3BR4R]

Hallo Forum,

beim booten wird mysqld nicht mehr gestartet...

wenn ich ein /etc/init.d/mysql start steht im syslog folgendes


Nov 26 08:24:43 localhost /etc/mysql/debian-start[6312]: Checking for crashed MySQL tables.
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]: WARNING: mysqlcheck has found corrupt tables
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]: /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL $
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]:
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]: Improperly closed tables are also reported if clients are accessing
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]: the tables *now*. A list of current connections is below.
Nov 26 08:24:43 localhost /etc/mysql/debian-start[6324]:
Nov 26 08:34:10 localhost mysqld_safe[6470]: started
Nov 26 08:34:10 localhost mysqld[6473]: nice: -: Datei oder Verzeichnis nicht gefunden
Nov 26 08:34:10 localhost mysqld_safe[6475]: ended
Nov 26 08:34:16 localhost /etc/init.d/mysql[6517]: 0 processes alive and '/usr/bin/mysqladmin --defaults-extra-file=/etc/mys$
Nov 26 08:34:16 localhost /etc/init.d/mysql[6517]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 26 08:34:16 localhost /etc/init.d/mysql[6517]: error: 'Can't connect to local MySQL server through socket '/var/run/mysq$
Nov 26 08:34:16 localhost /etc/init.d/mysql[6517]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld$
Nov 26 08:34:16 localhost /etc/init.d/mysql[6517]:

wenn ich aber einfach mysqld eingebe dann läuft der daemon

mysqld: ready for connections.
Version: '4.0.23_Debian-3ubuntu2.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 Source distribution

was mich stutzig macht ist port:0 ?? was hat das zu bedeuten?


vielen Dank schonmal.

[Tomek]

Wie sieht denn die Datei /etc/mysql/my.cnf bei dir aus?

[3BR4R]

hier meine cnf



[client]
password = "xxxxxxxxxx"
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
# Both location gets rotated by the cronjob.
log = /var/log/mysql.log
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# The skip-networking option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

[3BR4R]

vom manual werde ich nicht schlau, wieso läuft der daemon erst nachdem ich es selber eintippen muss?

[marce]

wie sind denn die Rechte von /var/run/mysqld und sämtlicher Dateien da drin?