MySQL Daemon failed to start.

[diab0583]

Есть vps
Centos
ispmanager .
MySQL автоматом не запускается, хотя в панели вроде как всё настроено.
Пытаюсь ручками запустить, не получается.

1.[root@***** ~]# service mysqld start
MySQL Daemon failed to start.

2.[root@itserebra ~]# /etc/rc.d/init.d/mysqld start
MySQL Daemon failed to start.
Starting MySQL: [FAILED]


Что делать, куда глядеть?

 

[Tele2]

Что в логах? /var/log/mysql/

 

[diab0583]

Среди всего этого есть только

httpd
700
root
root
4096
2010.11.28 00:43
mail
755
root
root
4096
2010.03.31 08:50
nginx
755
root
root
4096
2010.11.02 00:43
pm
755
root
root
4096
2009.09.30 01:17
boot.log.1
600
root
root
0
2010.11.21 00:43
boot.log.2
600
root
root
0
2010.11.14 00:43
boot.log.3
600
root
root
0
2010.11.08 00:43
boot.log.4
600
root
root
0
2010.11.01 00:43
btmp
600
root
utmp
20033280
2010.11.30 04:30
cron
600
root
root
13243
2010.12.01 11:01
cron.1
600
root
root
30459
2010.11.28 00:43
cron.2
600
root
root
20823
2010.11.21 00:43
cron.3
600
root
root
0
2010.11.08 00:43
cron.4
600
root
root
23792
2010.11.06 04:01
dmesg
644
root
root
34
2010.12.01 09:19
faillog
600
root
root
3232
2010.11.02 13:42
lastlog
644
root
root
147168
2010.12.01 10:32
maillog
600
root
root
28176017
2010.12.01 11:35
maillog.1
600
root
root
74446855
2010.11.28 00:43
maillog.2
600
root
root
39837875
2010.11.21 00:42
maillog.3
600
root
root
0
2010.11.08 00:43
maillog.4
600
root
root
8199284
2010.11.06 00:51
messages
600
root
root
17790
2010.12.01 11:01
messages.1
600
root
root
25324
2010.11.28 00:02
messages.2
600
root
root
26088
2010.11.21 00:01
messages.3
600
root
root
0
2010.11.08 00:43
messages.4
600
root
root
39828
2010.11.06 04:01
mysqld.log.rpmsave
640
mysql
mysql
1361
2010.11.02 13:19
rpmpkgs
644
root
root
12007
2010.12.01 00:43
rpmpkgs.1
644
root
root
11956
2010.11.27 00:43
rpmpkgs.2
644
root
root
11956
2010.11.20 00:43
rpmpkgs.3
644
root
root
11956
2010.11.13 00:43
rpmpkgs.4
644
root
root
11956
2010.11.06 00:44
secure
600
root
root
639685
2010.12.01 10:37
secure.1
600
root
root
3654803
2010.11.28 00:42
secure.2
600
root
root
2063774
2010.11.20 21:27
secure.3
600
root
root
0
2010.11.08 00:43
secure.4
600
root
root
1541325
2010.11.06 01:57
spooler
600
root
root
0
2010.11.28 00:43
spooler.1
600
root
root
0
2010.11.21 00:43
spooler.2
600
root
root
0
2010.11.14 00:43
spooler.3
600
root
root
0
2010.11.08 00:43
spooler.4
600
root
root
0
2010.11.01 00:43
tallylog
600
root
root
0
2010.04.09 18:35
wtmp
664
root
utmp
77568
2010.12.01 10:37
xferlog
600
root
root
1568
2010.11.28 18:10
xferlog.1
600
root
root
69596
2010.11.27 16:53
xferlog.2
600
root
root
0
2010.11.14 00:43
xferlog.3
600
root
root
851
2010.11.13 22:07
xferlog.4
600
root
root
853
2010.11.02 12:19
Выделено - 1

нашёл mysqld.log.rpmsave
вот его содержимое

101102 13:18:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
101102 13:18:35 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
101102 13:18:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101102 13:18:35  InnoDB: Started; log sequence number 0 13936710
101102 13:18:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
101102 13:18:35 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50077, now running 50150. Please use mysql_upgrade to fix this error.
101102 13:18:35 [ERROR] mysql.user has no `Event_priv` column at position 29
101102 13:18:35 [ERROR] Cannot open mysql.event
101102 13:18:35 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
101102 13:18:35 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.50'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
101102 13:19:18 [Note] /usr/libexec/mysqld: Normal shutdown
101102 13:19:18  InnoDB: Starting shutdown...
101102 13:19:21  InnoDB: Shutdown completed; log sequence number 0 13936710
101102 13:19:21 [Note] /usr/libexec/mysqld: Shutdown complete
101102 13:19:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

ещё нашёл mysqld.log
640
mysql
mysql
0
2010.12.01 10:32

но он пустой.
к консоли доступа нет( порты на рабочей машине закрыты

 

[NafanjaUa]

Please run mysql_upgrade to create it.

mysql_upgrade запустить надо, если есть крон то через него.

если нет такой комманды, то

mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables