Mysql Fehler in mysql.err

[Deejoy]

Hi,
ich habe ein Update auf Mysql 4.20 gemacht bzw. es neu installiert nachdem ich den alten gelöscht habe. Funktioniert soweit auch alles nur habe ich immer folgende fehlermeldung im mysql.err

Code: Alles auswählen

040720 22:23:26  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 '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
040720 22:23:30  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 '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
040720 22:23:30  mysqld started
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line
/usr/sbin/mysqld: ready for connections.
Version: '4.0.20-log'  socket: '/tmp/mysql.sock'  port: 3306

der link im tmp ordner exitstiert sonst würde phpmyadmin etc ja nicht funktionieren. nur warum bekomme ich diese fehlermeldung

[mistersixt]

Schau mal in /etc/mysql/my.cnf, ob sämtliche socket-Einträge auf den gleichen Pfad zeigen, bei mir sieht das zum Beispiel so aus:

Code: Alles auswählen

titan:~# grep -E '^socket' /etc/mysql/my.cnf
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
socket          = /var/run/mysqld/mysqld.sock
titan:~# 

Gruss, mistersixt.

[Deejoy]

Ja tun sie, hier der auszug

Code: Alles auswählen

# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password	= my_password
port		= 3306
socket		= /tmp/mysql.sock

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

[safe_mysqld]
err-log		= /var/log/mysql/mysql.err

[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /tmp/mysql.sock
port		= 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log		= /var/log/mysql/mysql.log
log		= /var/log/mysql.log
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-locking
#
# The skip-networkin 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
set-variable	= key_buffer=16M
set-variable	= max_allowed_packet=1M
set-variable	= thread_stack=128K
#
# Here you can see queries with especially long duration
#log-slow-queries	= /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id		= 1
#log-bin		= /var/log/mysql/mysql-bin.log
#binlog-do-db		= include_database_name
#binlog-ignore-db	= include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb

[mysqldump]
quick
set-variable	= max_allowed_packet=1M

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

[isamchk]
set-variable	= key_buffer=16M

[mistersixt]

Gibt es denn den Socket /tmp/mysql.sock ? Mach mal "ls -l /tmp".

Gruss, mistersixt.

[Deejoy]

da ist ein symlink gesetzt. Muß leider so sein weil sonst andere teile des System nicht gehen. Wenn ich diesen Link umbenenne geht auch mein phpmyadmin nicht daher gehe ich davon aus das er funktioniert. Ich weiß aber nicht wie ich überprüfen kann wohin dieser link geht oder wie man ihn neu setzt.

[Deejoy]

Code: Alles auswählen

xxxxxxxx:/home/user# ls -l/tmp
ls: invalid option -- /
Try `ls --help' for more information.
xxxxxxxx:/home/user# ls -l /tmp
total 8
srwxrwxrwx    1 mysql    mysql           0 Jul 21 00:29 mysql.sock
-rw-------    1 xxxxx webusers      258 Jul 20 23:48 sess_0314f32f0465033447f
11140bd8e79d8
-rw-------    1 xxxxx   webusers      350 Jul 21 00:27 sess_bb050f3939a23826a25
96dda0f06b810
-rw-------    1 root     root            0 Jul 21 02:41 vi.wjmjkp
217-20-118-12:/home/user# srwxrwxrwx    1 mysql    mysql           0 Jul 21 00:29 mysql.sock
bash: srwxrwxrwx: command not found
xxxxxxx:/home/user#

Also ich würde sagen der socket ist da