[+] Nie można uruchomi

Konfiguracja serwerów, usług, itp.
ODPOWIEDZ
wytrzeszcz
Posty: 21
Rejestracja: 12 kwietnia 2009, 20:10
Lokalizacja: Gdynia

[+] Nie można uruchomić MySQL

Post autor: wytrzeszcz »

Witam.
Mam następujący problem, pragnę uruchomić serwer MySQL na najnowszym Debianie(Squeeze 5). Instalacja najnowszej wersji przebiegła pomyślnie, jednak przy próbie uruchomienia uzyskuję:

Kod: Zaznacz cały

root@BizonDebWirt:/var/log#  /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
root@BizonDebWirt:/var/log# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Czytałem i szukałem w sieci już sporo jednak nie mogę znaleźć rozwiązania mojego problemu. Zdaję sobie sprawę iż nie umieściłem całości danych. Proszę o pomoc.

Edycja:
Przed chwilą zauważyłem również to:

Kod: Zaznacz cały

root@BizonDebWirt:/var/log# apt-get install htop
Czytanie list pakietów... Gotowe
Budowanie drzewa zależności
Odczyt informacji o stanie... Gotowe
The following packages were automatically installed and are no longer required:
  dbconfig-common php5-gd libmcrypt4 php5-mcrypt wwwconfig-common javascript-common libjs-mootools
Aby je usunąć należy użyć "apt-get autoremove".
Sugerowane pakiety:
  strace ltrace
Zostaną zainstalowane następujące NOWE pakiety:
  htop
0 aktualizowanych, 1 nowo instalowanych, 0 usuwanych i 0 nieaktualizowanych.
2 nie w pełni zainstalowanych lub usuniętych.
Konieczne pobranie 0 B/63,7 kB archiwów.
Po tej operacji zostanie dodatkowo użyte 209 kB miejsca na dysku.
Zaznaczenie poprzednio niezaznaczonego pakietu htop.
(Odczytywanie bazy danych ... 145888 files and directories currently installed.)
Rozpakowanie htop (z .../h/htop/htop_0.8.3-1_amd64.deb) ...
Przetwarzanie wyzwalaczy dla man-db...
Przetwarzanie wyzwalaczy dla desktop-file-utils...
Przetwarzanie wyzwalaczy dla gnome-menus...
Przetwarzanie wyzwalaczy dla menu...
Konfigurowanie mysql-server-5.1 (5.1.63-0+squeeze1) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: błąd przetwarzania mysql-server-5.1 (--configure):
 podproces zainstalowany skrypt post-installation zwrócił kod błędu 1
dpkg: problemy z zależnościami uniemożliwiają skonfigurowanie mysql-server:
 mysql-server zależy od mysql-server-5.1; jednakże:
  Pakiet mysql-server-5.1 nie jest jeszcze skonfigurowany.
dpkg: błąd przetwarzania mysql-server (--configure):
 problemy z zależnościami - pozostawiony nieskonfigurowany
Konfigurowanie htop (0.8.3-1) ...
configured to not write apport reports
                                      configured to not write apport reports
                                                                            Przetwarzanie wyzwalaczy dla menu...
Wystąpiły błędy podczas przetwarzania:
 mysql-server-5.1
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@BizonDebWirt:/var/log#

Edycja2:
Gdzieś wyczytałem, że zostawia logi w wybranych plikach:

Kod: Zaznacz cały

/var/log/mysql.err
/var/log/mysql.log
/var/log/mysql/mysql.log
Pierwsze dwa są puste, trzeci nie istnieje.
Edycja3:
Wykonałem upgrade systemu oraz na nowo zainstalowałem mysql problem nadal ten sam.
Na górę
fnmirk
Senior Member
Posty: 8295
Rejestracja: 03 grudnia 2007, 06:37

Post autor: fnmirk »

System zarządzania bazami danych MySQL nie jest rakietą aby go należało odpalać. Najnowszą wersją Debiana jest zawsze wersja Sid, odnośnie innych wersji należy to wyraźnie zaznaczyć. Np. najnowsza wersja stabilna Debiana (Squeeze) itp. Zamiast pisać wystarczy posłużyć się opisem:
http://debian.linux.pl/threads/12771-Za ... #post81406
Dostarczając odpowiednich informacji.

Przed instalacją czegokolwiek w systemie, należy go odpowiednio przygotować:
http://debian.linux.pl/threads/13294-Al ... #post84983
Na górę
piroaa
Beginner
Posty: 324
Rejestracja: 11 kwietnia 2008, 14:46

Post autor: piroaa »

Witam.
Sprawdź co masz w:

Kod: Zaznacz cały

/var/log/daemon.log
Pozdrawiam.
Na górę
wytrzeszcz
Posty: 21
Rejestracja: 12 kwietnia 2009, 20:10
Lokalizacja: Gdynia

Post autor: wytrzeszcz »

Kod: Zaznacz cały

Nov  1 13:41:08 BizonDebWirt /etc/init.d/mysql[5867]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 13:41:08 BizonDebWirt /etc/init.d/mysql[5867]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: To do so, start the server, then issue the following commands:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysqladmin -u root password 'new-password'
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysqladmin -u root -h BizonDebWirt password 'new-password'
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: Alternatively you can run:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysql_secure_installation
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: which will also give you the option of removing the test
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: databases and anonymous user created by default.  This is
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: strongly recommended for production servers.
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: See the manual for more instructions.
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: Please report any problems with the /usr/scripts/mysqlbug script!
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12225]: 121101 13:44:17 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12225]: 121101 13:44:17  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12225]: 121101 13:44:17  InnoDB: Completed initialization of buffer pool
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12225]: 121101 13:44:17  InnoDB: Started; log sequence number 0 44233
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12225]: 121101 13:44:17  InnoDB: Starting shutdown...
Nov  1 13:44:22 BizonDebWirt mysqld_safe[12225]: 121101 13:44:22  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:44:22 BizonDebWirt mysqld_safe[12263]: 121101 13:44:22 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: 121101 13:44:23  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: 121101 13:44:23  InnoDB: Completed initialization of buffer pool
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: 121101 13:44:23  InnoDB: Started; log sequence number 0 44233
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: 121101 13:44:23 [ERROR] Aborting
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]:
Nov  1 13:44:23 BizonDebWirt mysqld_safe[12263]: 121101 13:44:23  InnoDB: Starting shutdown...
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12263]: 121101 13:44:28  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12263]: 121101 13:44:28 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12263]:
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12296]: 121101 13:44:28 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12296]: 121101 13:44:28  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12296]: 121101 13:44:28  InnoDB: Completed initialization of buffer pool
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12296]: 121101 13:44:28  InnoDB: Started; log sequence number 0 44233
Nov  1 13:44:28 BizonDebWirt mysqld_safe[12296]: 121101 13:44:28  InnoDB: Starting shutdown...
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12296]: 121101 13:44:33  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33  InnoDB: Completed initialization of buffer pool
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33  InnoDB: Started; log sequence number 0 44233
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: ERROR: 1050  Table 'plugin' already exists
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33 [ERROR] Aborting
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]:
Nov  1 13:44:33 BizonDebWirt mysqld_safe[12331]: 121101 13:44:33  InnoDB: Starting shutdown...
Nov  1 13:44:39 BizonDebWirt mysqld_safe[12331]: 121101 13:44:39  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:44:39 BizonDebWirt mysqld_safe[12331]: 121101 13:44:39 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:44:39 BizonDebWirt mysqld_safe[12331]:
Nov  1 13:44:40 BizonDebWirt mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40  InnoDB: Completed initialization of buffer pool
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40  InnoDB: Started; log sequence number 0 44233
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40 [ERROR] Aborting
Nov  1 13:44:40 BizonDebWirt mysqld:
Nov  1 13:44:40 BizonDebWirt mysqld: 121101 13:44:40  InnoDB: Starting shutdown...
Nov  1 13:44:45 BizonDebWirt mysqld: 121101 13:44:45  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:44:45 BizonDebWirt mysqld: 121101 13:44:45 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:44:45 BizonDebWirt mysqld:
Nov  1 13:44:45 BizonDebWirt mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  1 13:44:54 BizonDebWirt /etc/init.d/mysql[12730]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  1 13:44:54 BizonDebWirt /etc/init.d/mysql[12730]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  1 13:44:54 BizonDebWirt /etc/init.d/mysql[12730]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  1 13:44:54 BizonDebWirt /etc/init.d/mysql[12730]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 13:44:54 BizonDebWirt /etc/init.d/mysql[12730]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: To do so, start the server, then issue the following commands:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: /usr/bin/mysqladmin -u root password 'new-password'
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: /usr/bin/mysqladmin -u root -h BizonDebWirt password 'new-password'
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: Alternatively you can run:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: /usr/bin/mysql_secure_installation
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: which will also give you the option of removing the test
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: databases and anonymous user created by default.  This is
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: strongly recommended for production servers.
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: See the manual for more instructions.
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]: Please report any problems with the /usr/scripts/mysqlbug script!
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13152]:
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13200]: 121101 13:46:38 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13200]: 121101 13:46:38  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13200]: 121101 13:46:38  InnoDB: Completed initialization of buffer pool
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13200]: 121101 13:46:38  InnoDB: Started; log sequence number 0 44233
Nov  1 13:46:38 BizonDebWirt mysqld_safe[13200]: 121101 13:46:38  InnoDB: Starting shutdown...
Nov  1 13:46:44 BizonDebWirt mysqld_safe[13200]: 121101 13:46:44  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49  InnoDB: Completed initialization of buffer pool
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49  InnoDB: Started; log sequence number 0 44233
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49 [ERROR] Aborting
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]:
Nov  1 13:46:49 BizonDebWirt mysqld_safe[13266]: 121101 13:46:49  InnoDB: Starting shutdown...
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13266]: 121101 13:46:55  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13266]: 121101 13:46:55 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13266]:
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13295]: 121101 13:46:55 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13295]: 121101 13:46:55  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13295]: 121101 13:46:55  InnoDB: Completed initialization of buffer pool
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13295]: 121101 13:46:55  InnoDB: Started; log sequence number 0 44233
Nov  1 13:46:55 BizonDebWirt mysqld_safe[13295]: 121101 13:46:55  InnoDB: Starting shutdown...
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13295]: 121101 13:47:00  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00  InnoDB: Completed initialization of buffer pool
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00  InnoDB: Started; log sequence number 0 44233
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: ERROR: 1050  Table 'plugin' already exists
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00 [ERROR] Aborting
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]:
Nov  1 13:47:00 BizonDebWirt mysqld_safe[13328]: 121101 13:47:00  InnoDB: Starting shutdown...
Nov  1 13:47:05 BizonDebWirt mysqld_safe[13328]: 121101 13:47:05  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:47:05 BizonDebWirt mysqld_safe[13328]: 121101 13:47:05 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:47:05 BizonDebWirt mysqld_safe[13328]:
Nov  1 13:47:06 BizonDebWirt mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06  InnoDB: Completed initialization of buffer pool
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06  InnoDB: Started; log sequence number 0 44233
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06 [ERROR] Aborting
Nov  1 13:47:06 BizonDebWirt mysqld:
Nov  1 13:47:06 BizonDebWirt mysqld: 121101 13:47:06  InnoDB: Starting shutdown...
Nov  1 13:47:11 BizonDebWirt mysqld: 121101 13:47:11  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:47:11 BizonDebWirt mysqld: 121101 13:47:11 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:47:11 BizonDebWirt mysqld:
Nov  1 13:47:11 BizonDebWirt mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  1 13:47:21 BizonDebWirt /etc/init.d/mysql[13728]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  1 13:47:21 BizonDebWirt /etc/init.d/mysql[13728]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  1 13:47:21 BizonDebWirt /etc/init.d/mysql[13728]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  1 13:47:21 BizonDebWirt /etc/init.d/mysql[13728]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 13:47:21 BizonDebWirt /etc/init.d/mysql[13728]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: To do so, start the server, then issue the following commands:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: /usr/bin/mysqladmin -u root password 'new-password'
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: /usr/bin/mysqladmin -u root -h BizonDebWirt password 'new-password'
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: Alternatively you can run:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: /usr/bin/mysql_secure_installation
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: which will also give you the option of removing the test
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: databases and anonymous user created by default.  This is
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: strongly recommended for production servers.
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: See the manual for more instructions.
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]: Please report any problems with the /usr/scripts/mysqlbug script!
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14707]:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Completed initialization of buffer pool
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: The first specified data file ./ibdata1 did not exist:
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: a new database to be created!
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Setting file ./ibdata1 size to 10 MB
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Database physically writes the file full: wait...
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Database physically writes the file full: wait...
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Database physically writes the file full: wait...
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Doublewrite buffer not found: creating new
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Doublewrite buffer created
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Creating foreign key constraint system tables
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: InnoDB: Foreign key constraint system tables created
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Started; log sequence number 0 0
Nov  1 13:50:12 BizonDebWirt mysqld_safe[14752]: 121101 13:50:12  InnoDB: Starting shutdown...
Nov  1 13:50:17 BizonDebWirt mysqld_safe[14752]: 121101 13:50:17  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23  InnoDB: Completed initialization of buffer pool
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23  InnoDB: Started; log sequence number 0 44233
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23 [ERROR] Aborting
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]:
Nov  1 13:50:23 BizonDebWirt mysqld_safe[14822]: 121101 13:50:23  InnoDB: Starting shutdown...
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14822]: 121101 13:50:28  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14822]: 121101 13:50:28 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14822]:
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14856]: 121101 13:50:28 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14856]: 121101 13:50:28  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14856]: 121101 13:50:28  InnoDB: Completed initialization of buffer pool
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14856]: 121101 13:50:28  InnoDB: Started; log sequence number 0 44233
Nov  1 13:50:28 BizonDebWirt mysqld_safe[14856]: 121101 13:50:28  InnoDB: Starting shutdown...
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14856]: 121101 13:50:34  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34  InnoDB: Completed initialization of buffer pool
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34  InnoDB: Started; log sequence number 0 44233
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: ERROR: 1050  Table 'plugin' already exists
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34 [ERROR] Aborting
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]:
Nov  1 13:50:34 BizonDebWirt mysqld_safe[14889]: 121101 13:50:34  InnoDB: Starting shutdown...
Nov  1 13:50:39 BizonDebWirt mysqld_safe[14889]: 121101 13:50:39  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:50:39 BizonDebWirt mysqld_safe[14889]: 121101 13:50:39 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:50:39 BizonDebWirt mysqld_safe[14889]:
Nov  1 13:50:40 BizonDebWirt mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40  InnoDB: Completed initialization of buffer pool
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40  InnoDB: Started; log sequence number 0 44233
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40 [ERROR] Aborting
Nov  1 13:50:40 BizonDebWirt mysqld:
Nov  1 13:50:40 BizonDebWirt mysqld: 121101 13:50:40  InnoDB: Starting shutdown...
Nov  1 13:50:46 BizonDebWirt mysqld: 121101 13:50:46  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:50:46 BizonDebWirt mysqld: 121101 13:50:46 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:50:46 BizonDebWirt mysqld:
Nov  1 13:50:46 BizonDebWirt mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  1 13:50:54 BizonDebWirt /etc/init.d/mysql[15288]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  1 13:50:54 BizonDebWirt /etc/init.d/mysql[15288]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  1 13:50:54 BizonDebWirt /etc/init.d/mysql[15288]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  1 13:50:54 BizonDebWirt /etc/init.d/mysql[15288]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 13:50:54 BizonDebWirt /etc/init.d/mysql[15288]:
Nov  1 13:51:14 BizonDebWirt mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14  InnoDB: Completed initialization of buffer pool
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14  InnoDB: Started; log sequence number 0 44233
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14 [ERROR] Aborting
Nov  1 13:51:14 BizonDebWirt mysqld:
Nov  1 13:51:14 BizonDebWirt mysqld: 121101 13:51:14  InnoDB: Starting shutdown...
Nov  1 13:51:20 BizonDebWirt mysqld: 121101 13:51:20  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 13:51:20 BizonDebWirt mysqld: 121101 13:51:20 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 13:51:20 BizonDebWirt mysqld:
Nov  1 13:51:20 BizonDebWirt mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  1 13:51:29 BizonDebWirt /etc/init.d/mysql[15721]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  1 13:51:29 BizonDebWirt /etc/init.d/mysql[15721]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  1 13:51:29 BizonDebWirt /etc/init.d/mysql[15721]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  1 13:51:29 BizonDebWirt /etc/init.d/mysql[15721]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 13:51:29 BizonDebWirt /etc/init.d/mysql[15721]:
Nov  1 14:07:35 BizonDebWirt mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35 [Note] Plugin 'FEDERATED' is disabled.
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35  InnoDB: Initializing buffer pool, size = 8.0M
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35  InnoDB: Completed initialization of buffer pool
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35  InnoDB: Started; log sequence number 0 44233
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35 [ERROR] Aborting
Nov  1 14:07:35 BizonDebWirt mysqld:
Nov  1 14:07:35 BizonDebWirt mysqld: 121101 14:07:35  InnoDB: Starting shutdown...
Nov  1 14:07:41 BizonDebWirt mysqld: 121101 14:07:41  InnoDB: Shutdown completed; log sequence number 0 44233
Nov  1 14:07:41 BizonDebWirt mysqld: 121101 14:07:41 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  1 14:07:41 BizonDebWirt mysqld:
Nov  1 14:07:41 BizonDebWirt mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Nov  1 14:07:50 BizonDebWirt /etc/init.d/mysql[19520]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov  1 14:07:50 BizonDebWirt /etc/init.d/mysql[19520]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov  1 14:07:50 BizonDebWirt /etc/init.d/mysql[19520]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov  1 14:07:50 BizonDebWirt /etc/init.d/mysql[19520]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov  1 14:07:50 BizonDebWirt /etc/init.d/mysql[19520]:
root@BizonDebWirt:/home/jakub#
Ja wiem, spore, ale lepiej wiecej niż za mało co nie? Jest to wynik polecenia:

Kod: Zaznacz cały

cat /var/log/daemon.log | grep mysql
Na górę
piroaa
Beginner
Posty: 324
Rejestracja: 11 kwietnia 2008, 14:46

Post autor: piroaa »

Tak na szybko :

Kod: Zaznacz cały

[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] Do you already have another mysqld server running on port: 3306 ?
[ERROR] Aborting
W związku z powyższym:

Kod: Zaznacz cały

netstat -ltn | grep 3306
i jeszcze:

Kod: Zaznacz cały

ps ax | grep mys
Jak nic z tego nie wyniknie to szukaj w logu słowa [ERROR], a jak poszukasz to zauważysz
że się jeszcze kilka razy powtórzyło, to co po nim wrzucaj do Google, na 100% ktoś
już taki problem miał i rozwiązanie na pewno zostało znalezione.
Pozdrawiam.
Na górę
wytrzeszcz
Posty: 21
Rejestracja: 12 kwietnia 2009, 20:10
Lokalizacja: Gdynia

Post autor: wytrzeszcz »

Kod: Zaznacz cały

root@BizonDebWirt:/var/www/jakub# netstat -ltn |grep 3306
root@BizonDebWirt:/var/www/jakub# ps ax|grep mys
13140 pts/1    S+     0:00 grep mys
root@BizonDebWirt:/var/www/jakub#
Czy to może być coś z firewallem?
Na górę
piroaa
Beginner
Posty: 324
Rejestracja: 11 kwietnia 2008, 14:46

Post autor: piroaa »

Witam.
A czytałeś tego error loga w ogóle?
A tam stoi:

Kod: Zaznacz cały

Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: To do so, start the server, then issue the following commands:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysqladmin -u root password 'new-password'
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysqladmin -u root -h BizonDebWirt password 'new-password'
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: Alternatively you can run:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: /usr/bin/mysql_secure_installation
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: which will also give you the option of removing the test
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: databases and anonymous user created by default.  This is
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: strongly recommended for production servers.
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]:
Nov  1 13:44:17 BizonDebWirt mysqld_safe[12179]: See the manual for more instructions.
Czyli, wpisujesz:

Kod: Zaznacz cały

mysql_secure_installation
i postępujesz zgodnie z instrukcją, sprawdzasz czy działa.
Na górę
wytrzeszcz
Posty: 21
Rejestracja: 12 kwietnia 2009, 20:10
Lokalizacja: Gdynia

Post autor: wytrzeszcz »

Próbowałem to:

Kod: Zaznacz cały

mysql_secure_installation
ale:

Kod: Zaznacz cały

root@BizonDebWirt:/home/jakub# /usr/bin/mysql_secure_installation




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Enter current password for root (enter for none):
Na górę
piroaa
Beginner
Posty: 324
Rejestracja: 11 kwietnia 2008, 14:46

Post autor: piroaa »

Witam.
Jedyne rozwiązanie jakie jakie znalazłem to wywalić MySQL razem z plikami konfiguracyjnymi, no i na koniec jeśli w bazie nic nie ma wywalić katalog /var/lib/mysql/ .
Następnie ponowna instalacja serwera.
Jeśli powyższe nie pomoże to ja już nie wiem co może ci pomóc.
Pozdrawiam.
Na górę
wytrzeszcz
Posty: 21
Rejestracja: 12 kwietnia 2009, 20:10
Lokalizacja: Gdynia

Post autor: wytrzeszcz »

Wczoraj późnym wieczorem rozgryzłem z pomocą znajomego co nie działało. Okazało się, że trzeba było zmienić ustawienia przy interfejsach sieciowych i podnieść lo (loopback). Mimo wszystko Serdeczne Bóg zapłać dla piroaa za pomoc w dochodzeniu co jest nie tak.
Na górę
ODPOWIEDZ

Wróć do „Serwer”