Dotaz: Nestartuje Debiani MySQL

[pele]

Zdravim, mam takovy maly problem s distribucni databazi MySQL. Proste ne a ne ji nastartovat. Na Debianu/unstable funguje vse jak ma ale Etch me zlobi. Dopadne to vzdy takhle:

# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Z logu sem se dovedel ze se nevytvari MySQL socket:

Nov 17 23:15:59 a03-0634b mysqld_safe[15545]: started
Nov 17 23:15:59 a03-0634b mysqld[15550]: 061117 23:15:59  InnoDB: Started; log sequence number 0 43655
Nov 17 23:15:59 a03-0634b mysqld[15550]: 061117 23:15:59 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov 17 23:15:59 a03-0634b mysqld[15550]: 061117 23:15:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov 17 23:15:59 a03-0634b mysqld[15550]: 061117 23:15:59 [ERROR] Aborting
Nov 17 23:15:59 a03-0634b mysqld[15550]: 
Nov 17 23:15:59 a03-0634b mysqld[15550]: 061117 23:15:59  InnoDB: Starting shutdown...
Nov 17 23:16:01 a03-0634b mysqld[15550]: 061117 23:16:01  InnoDB: Shutdown completed; log sequence number 0 43655
Nov 17 23:16:01 a03-0634b mysqld[15550]: 061117 23:16:01 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 17 23:16:01 a03-0634b mysqld[15550]: 
Nov 17 23:16:01 a03-0634b mysqld_safe[15576]: ended
Nov 17 23:16:13 a03-0634b /etc/init.d/mysql[15707]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 17 23:16:13 a03-0634b /etc/init.d/mysql[15707]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 17 23:16:13 a03-0634b /etc/init.d/mysql[15707]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 17 23:16:13 a03-0634b /etc/init.d/mysql[15707]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 17 23:16:13 a03-0634b /etc/init.d/mysql[15707]: 

Ale proc se sakra nevytvari, prava /var/run/mysql jsou v poradku, tak uz nevim.

Poradi nekdo, dekuji.

Odpovědi

[Messa]

To vypadá, jako kdyby na portu 3306 už něco běželo. Zkontroluj příkazem

netstat -nltp

[pele]

Tohle me taky napadlo ale ne, nic na standardnim portu MySQL nebezi.

[pele]

Jeste sem zapomnel dodat ze je to MySQL 5.0.26-3

[Libor Klepac]

jestli tu sit nutne nepotrebujes, tak zkus do my.cnf pridat skip-networking, tedy jestli je tohle opravdu ten problem .....

[pele]

No jasne, opet chyba mezi klavesnici a zidli. my.cnf sem prevzal z druheho pocitace ktery mel povoleno networking a navic byl nabindovan na jinou IP.

Dekuji