Gentoo Archives: gentoo-user-de

From: Thomas Bruns <newsgroup@××××××××.de>
To: gentoo-user-de@l.g.o
Subject: Re: [gentoo-user-de] MYSQL: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Date: Sat, 22 Oct 2005 16:07:49
Message-Id: 200510221804.59778.newsgroup@donbruno.de
In Reply to: Re: [gentoo-user-de] MYSQL: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) by Bernd Wurst
1 Am Samstag, 22. Oktober 2005 13:20 schrieb Bernd Wurst:
2 > Hallo.
3 >
4 > Wer sagt das?
5 Hatte ich bei google rausgefunden... bin aber aus der Fehlerbehebung nicht
6 schlau geworden
7 >
8 > Läuft der Server (ps aux|grep mysqld)?
9 ne, der läuft gar nicht :-(
10 > Wenn nein, was sagt /var/log/mysql/*.
11 less /var/log/mysql/mysqld.err :
12 InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes
13 InnoDB: than specified in the .cnf file 0 5242880 bytes!
14 051022 17:58:24 [ERROR] Can't init databases
15 051022 17:58:24 [ERROR] Aborting
16 051022 17:58:24 [Note] /usr/sbin/mysqld: Shutdown complete
17
18 >
19 > Wenn ja, welchen Socket benutzt er? (find /var/run -name mysql*)
20 thomas # find /var/run -name mysql*
21 /var/run/mysqld
22 /var/run/mysqld/mysqld.sock
23
24 hier mal ein auszug aus meiner my.cnf:
25 [mysqld]
26 character-set-server = latin1
27 default-character-set = latin1
28 user = mysql
29 port = 3306
30 socket = /var/run/mysqld/mysqld.sock
31 pid-file = /var/run/mysqld/mysqld.pid
32 log-error = /var/log/mysql/mysqld.err
33 basedir = /usr
34 datadir = /var/lib/mysql
35 skip-locking
36 #skip-innodb
37 key_buffer = 16M
38 max_allowed_packet = 1M
39 table_cache = 64
40 sort_buffer_size = 512K
41 net_buffer_length = 8K
42 read_buffer_size = 256K
43 read_rnd_buffer_size = 512K
44 myisam_sort_buffer_size = 8M
45 language = /usr/share/mysql/english
46
47 mmhhh und nun?
48
49 Gruss
50 THomas
51
52
53 --
54 gentoo-user-de@g.o mailing list

Replies