michalmw
(michalmw)
26 Listopad 2011 09:29
#1
Witam,
Nagle padł mi mysql
Gdy chce włączyć, wyłaczyć albo zresetować dostaje taką odpowiedz:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Nie znalazłem w internecie nigdzie odpowiedzi w prost co należy zrobić.
Zauważyłem że tego pliki mysql.sock nie ma w tamtym miejscu i może to jest tym spowodowane.
Reinstalacja mysql-server-5.0 nic nie dała.
Debian lub Ubuntu Server?
sudo /etc/init.d/mysql restart
Wklej to co ta komenda pokaże…
michalmw
(michalmw)
26 Listopad 2011 10:13
#3
Ubuntu Server:
Próbowałem
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Nie ma tam tego pliku, probowałem w my.conf zmienić pliki na /tmp/mysqld.sock ale to nic nie pomogło.
Poszukaj logów z serwera MySQL - prawdopodobne lokalizacje:
/var/log/mysql/error.log
/var/log/mysql.*
Powinno być tutaj napisane dlaczego serwer nie wstaje…
michalmw
(michalmw)
26 Listopad 2011 10:30
#5
Mam ten plik wygląda on tak:… Ale to mi nic nie mówi ;/
111126 11:09:04 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:04 [ERROR] Aborting
111126 11:09:04 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:04 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:04 InnoDB: Started; log sequence number 0 44467584
111126 11:09:04 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:04 [ERROR] Aborting
111126 11:09:04 InnoDB: Starting shutdown...
111126 11:09:09 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:09 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:09 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:09 InnoDB: Started; log sequence number 0 44467584
111126 11:09:09 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:09 [ERROR] Aborting
111126 11:09:09 InnoDB: Starting shutdown...
111126 11:09:14 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:14 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:14 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:14 InnoDB: Started; log sequence number 0 44467584
111126 11:09:14 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:14 [ERROR] Aborting
111126 11:09:14 InnoDB: Starting shutdown...
111126 11:09:20 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:20 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:20 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:20 InnoDB: Started; log sequence number 0 44467584
111126 11:09:20 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:20 [ERROR] Aborting
111126 11:09:20 InnoDB: Starting shutdown...
111126 11:09:25 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:25 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:25 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:26 InnoDB: Started; log sequence number 0 44467584
111126 11:09:26 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:26 [ERROR] Aborting
111126 11:09:26 InnoDB: Starting shutdown...
111126 11:09:32 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:32 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:09:43 [Note] Plugin 'FEDERATED' is disabled.
111126 11:09:43 InnoDB: Started; log sequence number 0 44467584
111126 11:09:43 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:09:43 [ERROR] Aborting
111126 11:09:43 InnoDB: Starting shutdown...
111126 11:09:49 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:09:49 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:10:13 [Note] Plugin 'FEDERATED' is disabled.
111126 11:10:13 InnoDB: Started; log sequence number 0 44467584
111126 11:10:13 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:10:13 [ERROR] Aborting
111126 11:10:13 InnoDB: Starting shutdown...
111126 11:10:19 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:10:19 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:10:43 [Note] Plugin 'FEDERATED' is disabled.
111126 11:10:43 InnoDB: Started; log sequence number 0 44467584
111126 11:10:43 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:10:43 [ERROR] Aborting
111126 11:10:43 InnoDB: Starting shutdown...
111126 11:10:49 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:10:49 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:11:14 [Note] Plugin 'FEDERATED' is disabled.
111126 11:11:14 InnoDB: Started; log sequence number 0 44467584
111126 11:11:14 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:11:14 [ERROR] Aborting
111126 11:11:14 InnoDB: Starting shutdown...
111126 11:11:19 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:11:19 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:11:44 [Note] Plugin 'FEDERATED' is disabled.
111126 11:11:44 InnoDB: Started; log sequence number 0 44467584
111126 11:11:44 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:11:44 [ERROR] Aborting
111126 11:11:44 InnoDB: Starting shutdown...
111126 11:11:49 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:11:49 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:12:14 [Note] Plugin 'FEDERATED' is disabled.
111126 11:12:14 InnoDB: Started; log sequence number 0 44467584
111126 11:12:14 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:12:14 [ERROR] Aborting
111126 11:12:14 InnoDB: Starting shutdown...
111126 11:12:19 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:12:19 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:12:44 [Note] Plugin 'FEDERATED' is disabled.
111126 11:12:44 InnoDB: Started; log sequence number 0 44467584
111126 11:12:44 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:12:44 [ERROR] Aborting
111126 11:12:44 InnoDB: Starting shutdown...
111126 11:12:49 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:12:49 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:13:14 [Note] Plugin 'FEDERATED' is disabled.
111126 11:13:16 InnoDB: Started; log sequence number 0 44467584
111126 11:13:16 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:13:16 [ERROR] Aborting
111126 11:13:16 InnoDB: Starting shutdown...
111126 11:13:22 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:13:22 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:13:44 [Note] Plugin 'FEDERATED' is disabled.
111126 11:13:44 InnoDB: Started; log sequence number 0 44467584
111126 11:13:44 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:13:44 [ERROR] Aborting
111126 11:13:44 InnoDB: Starting shutdown...
111126 11:13:52 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:13:52 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:14:14 [Note] Plugin 'FEDERATED' is disabled.
111126 11:14:14 InnoDB: Started; log sequence number 0 44467584
111126 11:14:14 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:14:14 [ERROR] Aborting
111126 11:14:14 InnoDB: Starting shutdown...
111126 11:14:20 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:14:20 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:14:45 [Note] Plugin 'FEDERATED' is disabled.
111126 11:14:45 InnoDB: Started; log sequence number 0 44467584
111126 11:14:45 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:14:45 [ERROR] Aborting
111126 11:14:45 InnoDB: Starting shutdown...
111126 11:14:50 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:14:50 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:15:15 [Note] Plugin 'FEDERATED' is disabled.
111126 11:15:15 InnoDB: Started; log sequence number 0 44467584
111126 11:15:15 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:15:15 [ERROR] Aborting
111126 11:15:15 InnoDB: Starting shutdown...
111126 11:15:20 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:15:20 [Note] /usr/sbin/mysqld: Shutdown complete
111126 11:15:45 [Note] Plugin 'FEDERATED' is disabled.
111126 11:15:45 InnoDB: Started; log sequence number 0 44467584
111126 11:15:45 [ERROR] /usr/sbin/mysqld: unknown option '--socjopata'
111126 11:15:45 [ERROR] Aborting
111126 11:15:45 InnoDB: Starting shutdown...
111126 11:15:50 InnoDB: Shutdown completed; log sequence number 0 44467584
111126 11:15:50 [Note] /usr/sbin/mysqld: Shutdown complete
Wystarczy, że usuniesz argument “–socjopata” i MySQL uruchomi się normalnie…
michalmw
(michalmw)
26 Listopad 2011 10:45
#7
A podpowiesz jak to zrobic? Nie spotkałem się z tym argumentem i nie wiem jak włączyć bez tego argumentu.
Poniższa komenda znajdzie “–socjopata” w plikach konfiguracyjnych i wyświetli ścieżke do pliku w katalog /etc/:
grep -lir "--socjopata" /etc/
Oczywiście skuteczne, jeżeli tam jest zapisany ten argument, ewentualnie poszukaj “socjopata” jeżeli nic nie znajdzie dla “–socjopata”…
michalmw
(michalmw)
26 Listopad 2011 10:57
#9
Nic nie znalazło w --socopata… A jak chodzi o samego socjopata to znalazło w
/etc/mysql/conf.d/old_passwords.cnf
A ten plik tworzyłem w jednym ze stron z rozwiązaniem – nie dało efektow ale plik został. usunełem to ‘socjopata’ ale problem nadal taki sam został. Innym pomysł?