habe den Server neugestartet und habe mich gewundert warum mysql nicht mehr geht also mysqld als error bekomm ich:
mysqld: ERROR: unknown option '--2'
Ich nutze Debian woody und auch rein apt-get remove und install auch mit purge hat nix gebracht auch der Versuch von 4.0.20 auf 0.18 zu wechseln hat nichts gebracht ein strace gibt folgendes aus:
Am anfang existierte die /root/.my.ncf nicht, da hab die von /etc/mysql/my.cnf genutzt:~# strace mysqld
execve("/usr/sbin/mysqld", ["mysqld"], [/* 14 vars */]) = 0
uname({sys="Linux", node="server1", ...}) = 0
brk(0) = 0x841af28
open("/etc/ld.so.preload", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
close(3) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=12780, ...}) = 0
old_mmap(NULL, 12780, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40014000
close(3) = 0
open("/lib/librt.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\030031"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=23388, ...}) = 0
old_mmap(NULL, 69012, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40018000
mprotect(0x4001e000, 44436, PROT_NONE) = 0
old_mmap(0x4001e000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x5000) = 0x4001e000
old_mmap(0x4001f000, 40340, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4001f000
close(3) = 0
open("/lib/libwrap.so.0", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0@ \0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=24328, ...}) = 0
old_mmap(NULL, 29092, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40029000
mprotect(0x4002f000, 4516, PROT_NONE) = 0
old_mmap(0x4002f000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x5000) = 0x4002f000
old_mmap(0x40030000, 420, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40030000
close(3) = 0
open("/lib/libdl.so.2", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0T27\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=8008, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40031000
old_mmap(NULL, 11004, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40032000
mprotect(0x40034000, 2812, PROT_NONE) = 0
old_mmap(0x40034000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x1000) = 0x40034000
close(3) = 0
open("/usr/lib/libssl.so.0.9.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0260215"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=182084, ...}) = 0
old_mmap(NULL, 182848, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40035000
mprotect(0x4005f000, 10816, PROT_NONE) = 0
old_mmap(0x4005f000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x2a000) = 0x4005f000
close(3) = 0
open("/usr/lib/libcrypto.so.0.9.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\024036"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=771908, ...}) = 0
old_mmap(NULL, 783840, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40062000
mprotect(0x40114000, 54752, PROT_NONE) = 0
old_mmap(0x40114000, 45056, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xb2000) = 0x40114000
old_mmap(0x4011f000, 9696, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4011f000
close(3) = 0
open("/lib/libpthread.so.0", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0`C\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=102172, ...}) = 0
old_mmap(NULL, 81316, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40122000
mprotect(0x4012f000, 28068, PROT_NONE) = 0
old_mmap(0x4012f000, 28672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xd000) = 0x4012f000
close(3) = 0
open("/usr/lib/libz.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\020030"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=55432, ...}) = 0
old_mmap(NULL, 54460, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40136000
mprotect(0x40142000, 5308, PROT_NONE) = 0
old_mmap(0x40142000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0xc000) = 0x40142000
close(3) = 0
open("/lib/libcrypt.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0320t\0"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=19136, ...}) = 0
old_mmap(NULL, 182044, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40144000
mprotect(0x40149000, 161564, PROT_NONE) = 0
old_mmap(0x40149000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x4000) = 0x40149000
old_mmap(0x4014a000, 157468, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4014a000
close(3) = 0
open("/lib/libnsl.so.1", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0 ;\0\000"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=69472, ...}) = 0
old_mmap(NULL, 80988, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40171000
mprotect(0x40182000, 11356, PROT_NONE) = 0
old_mmap(0x40182000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x10000) = 0x40182000
old_mmap(0x40183000, 7260, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40183000
close(3) = 0
open("/usr/lib/libstdc++-libc6.2-2.so.3", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\0P2331"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=288540, ...}) = 0
old_mmap(NULL, 296708, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40185000
mprotect(0x401bb000, 75524, PROT_NONE) = 0
old_mmap(0x401bb000, 69632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x36000) = 0x401bb000
old_mmap(0x401cc000, 5892, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401cc000
close(3) = 0
open("/lib/libm.so.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\02007\0"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0644, st_size=130088, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x401ce000
old_mmap(NULL, 132708, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401cf000
mprotect(0x401ef000, 1636, PROT_NONE) = 0
old_mmap(0x401ef000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x1f000) = 0x401ef000
close(3) = 0
open("/lib/libc.so.6", O_RDONLY) = 3
read(3, "177ELF111\0\0\0\0\0\0\0\0\03\03\01\0\0\030222"..., 1024) = 1024
fstat64(3, {st_mode=S_IFREG|0755, st_size=1153784, ...}) = 0
old_mmap(NULL, 1166560, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x401f0000
mprotect(0x40303000, 40160, PROT_NONE) = 0
old_mmap(0x40303000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x113000) = 0x40303000
old_mmap(0x40309000, 15584, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40309000
close(3) = 0
munmap(0x40014000, 12780) = 0
getrlimit(0x3, 0xbffffbfc) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=2044*1024, rlim_max=RLIM_INFINITY}) = 0
getpid() = 3191
uname({sys="Linux", node="server1", ...}) = 0
rt_sigaction(SIGRTMIN, {0x4012a480, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x4012a508, [], 0x4000000}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x4012a608, [], 0x4000000}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [RTMIN], NULL, 8) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xbffffa04, 34, (nil), 0}) = 0
brk(0) = 0x841af28
brk(0x841af58) = 0x841af58
brk(0x841b000) = 0x841b000
brk(0x841c000) = 0x841c000
open("/etc/localtime", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=837, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\010\0\0\010"..., 4096) = 837
close(3) = 0
munmap(0x40014000, 4096) = 0
time(NULL) = 1092084510
uname({sys="Linux", node="server1", ...}) = 0
stat64("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=2663, ...}) = 0
open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2663, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "#n# The MySQL database server co"..., 4096) = 2663
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
stat64("/var/lib/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=48, ...}) = 0
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=48, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "# This file must exist - CAN-200"..., 4096) = 48
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
stat64("/root/.my.cnf", {st_mode=S_IFREG|0644, st_size=2661, ...}) = 0
open("/root/.my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2661, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
read(3, "#n# The MySQL database server co"..., 4096) = 2661
read(3, "", 4096) = 0
close(3) = 0
munmap(0x40014000, 4096) = 0
write(2, "mysqld: ERROR: unknown option '-"..., 36mysqld: ERROR: unknown option '--2'
) = 36
_exit(2) = ?
Leider hab ich nix gefunden was die Ursache sein könnte.#
# 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]
err-log = /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
#
# 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.log
log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
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 = 32M
#thread_stack = 128K
2
# 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 = 50M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M