Nie mogę uruchomić serwera mysql

[baltazar_gabka 0]

Witam.

Mam problem z uruchomieniem mysql.

 

/etc/init.d/mysql restart

 

Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

 

mysql -u root -p

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

Mój plik /etc/mysql/my.cnf

 

[client]
port			= 3306
socket		  = /var/run/mysqld/mysqld.sock


[mysqld_safe]
socket		  = /var/run/mysqld/mysqld.sock
nice			= 0


user			= mysql
pid-file		= /var/run/mysqld/mysqld.pid
socket		  = /var/run/mysqld/mysqld.sock
port			= 3306
basedir		 = /usr
datadir		 = /var/lib/mysql
tmpdir		  = /tmp
language		= /usr/share/mysql/english
skip-external-locking


key_buffer			  = 16M
max_allowed_packet	  = 16M
thread_stack			= 128K
thread_cache_size	   = 8


query_cache_limit	   = 1M
query_cache_size		= 16M


expire_logs_days		= 10


[mysqldump]
quick
quote-names
max_allowed_packet	  = 16M


[isamchk]
key_buffer			  = 16M


!includedir /etc/mysql/conf.d/

 

Co poprawić aby serwer mysql działał poprawnie.

[regdos 1848]

Zobacz co jest w logach, dlaczego przy starcie jest Failed.

[baltazar_gabka 0]

W syslog mam coś takiego:

 

 

Apr  7 19:21:48 13856 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [Note] Plugin 'FEDERATED' is disabled.
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [Note] Plugin 'InnoDB' is disabled.
Apr  7 19:21:48 13856 mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [ERROR] Aborting
Apr  7 19:21:48 13856 mysqld:
Apr  7 19:21:48 13856 mysqld: 120407 19:21:48 [Note] /usr/sbin/mysqld: Shutdown complete
Apr  7 19:21:48 13856 mysqld:
Apr  7 19:21:48 13856 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Apr  7 19:22:02 13856 /etc/init.d/mysql[1589]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr  7 19:22:02 13856 /etc/init.d/mysql[1589]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr  7 19:22:02 13856 /etc/init.d/mysql[1589]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr  7 19:22:02 13856 /etc/init.d/mysql[1589]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr  7 19:22:02 13856 /etc/init.d/mysql[1589]:

 

Plików mysql.err i mysql.log nie mam w /var/log

[regdos 1848]

Apr 7 19:21:48 13856 mysqld: 120407 19:21:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Apr 7 19:21:48 13856 mysqld: 120407 19:21:48 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'

 

tutaj masz powody.

[baltazar_gabka 0]

Po wydaniu polecenia

 

mysql_upgrade

mam takie błędy::

 

 

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' 
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

[patryk 451]

Zacznij od wywalenia skip-bdb z my.cnf.

[baltazar_gabka 0]

Teraz ruszyło.

 

Mam tylko jeszcze komunikat:

 

 

Checking for corrupt, not cleanly closed and upgrade needing tables..

[Gość patrys]

zignoruj...

[furek 37]

Dokładnie ;-)

[d.v 1409]

Dodać należałoby dla jasności, że to nie jest żaden komunikat o nieprawidłowościach, wszystkie nowsze wersje MySQL mają ten komunikat wbudowany, jest to zwykła informacja o mikro-debugu, który MySQL sam sobie uruchamia przy starcie serwera.