mysql: dove sta /var/run/mysqld/mysqld.sock?
Salve a tutti... aggiornata ad oggi la mia sid e fatto il mio bel
reboottino... Mysql si incazza e si rifiuta di partire...
A quanto pare non trova /var/run/mysqld/mysqld.sock (che effettivamente
non esiste). Googolo un pelo e pare che commentando una riga
in /etc/mysql/my.cnf si risolva, la riga è:
old_passwords = 1
il che mi puzza, troppo semplice. E infatti siamo punto e a capo:
cat /var/log/syslog | grep mysql:
------------------------------------------------------------------------
Oct 9 15:37:13 brasato mysqld_safe[3958]: started
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14 InnoDB: Started;
log sequence number 0 463608
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14 [Note] Recovering
after a crash using /var/log/mysql/mysql-bin
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14 [Note] Starting
crash recovery...
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14 [Note] Crash
recovery finished.
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14
[ERROR] /usr/sbin/mysqld: Incorrect information in file:
'./mysql/user.frm'
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14
[ERROR] /usr/sbin/mysqld: Incorrect information in file:
'./mysql/user.frm'
Oct 9 15:37:14 brasato mysqld[3961]: 061009 15:37:14 [ERROR] Fatal
error: Can't open and lock privilege tables: Incorrect information in
file: './mysql/user.frm'
Oct 9 15:37:14 brasato mysqld_safe[3981]: ended
Oct 9 15:37:28 brasato /etc/init.d/mysql[4107]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Oct 9 15:37:28 brasato /etc/init.d/mysql[4107]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Oct 9 15:37:28 brasato /etc/init.d/mysql[4107]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 9 15:37:28 brasato /etc/init.d/mysql[4107]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 9 15:37:28 brasato /etc/init.d/mysql[4107]:
--------------------------------------------------------------------------
Qualcuno ha qualche idea?
Alberto Stracuzzi
Reply to: