mysql.sock

[Schwarzer'Engel]

Hi,

ich habe ein Problem mit meinem MySQl-Server. Ich habe in der Datei my.cnf die Pfade für mysqld.sock nach /var/run/mysqld/mysqld.sock verlegt. Der Server läuft auch und ich kann z.b. per phpMyAdmin auf die Datenbanken zugreifen.

Versuche ich jetzt aber per Konsole mysqldump auszuführen oder mich auf der Konsole mit mysql -u xxx -p auf den Server zu connecten erscheint folgender Fehler:



ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Was habe ich übersehen ?

Danke & Gruß
Chris

[Tomek]

Kannst du bitte mal deine MySQL-Konfiguration (my.cnf) hier posten?

[Schwarzer'Engel]

Kannst du bitte mal deine MySQL-Konfiguration (my.cnf) hier posten?

Hatte die letzten Tage keine Zeit zu posten. Aber hier meine my.cnf :



#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
[client]
#password = my_password
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]
log-err = /var/log/mysql/mysql.err
socket = /var/run/mysqld/mysqld.sock

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
log-err = /var/log/mysql/mysql.err

#
# 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
basedir = /usr/local/mysql/current
datadir = /usr/local/mysql/current/data
tmpdir = /tmp
language = /usr/local/mysql/current/share/mysql/english

#(Unknown option:)skip-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 = 1M
thread_stack=128
#
# Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1
#
# 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
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
max_allowed_packet = 1M

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

[isamchk]
key_buffer = 16M

[marce]

Alternativ kannst Du auch mit -S den Pfad zum Socket direkt angeben.

[Schwarzer'Engel]

Alternativ kannst Du auch mit -S den Pfad zum Socket direkt angeben.


Ja das funktioniert so, aber ist irgendie lästig :(

[temir]

damit es nicht mehr lästig ist, solltest du im $HOME eine '.my.cnf' mit dem Inhalt:
----------------------
[client]
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock
---------------------
anlegen