Mysql

обновились сегодня до сквизи и началось, мускул отказался работать.
Переустановили, кое как работает, теперь при установке любого пакета, запускается конфигурация мускула..

[console]
Настраивается пакет mysql-server-5.1 (5.1.49-3) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
/etc/init.d/mysql: line 120: /etc/mysql/debian-start: Нет такого файла или каталога
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: не удалось обработать параметр mysql-server-5.1 (--configure):
подпроцесс установлен сценарий post-installation возвратил код ошибки 127
dpkg: зависимости пакетов не позволяют настроить пакет mysql-server:
mysql-server зависит от mysql-server-5.1, однако:
Пакет mysql-server-5.1 пока не настроен.
dpkg: не удалось обработать параметр mysql-server (--configure):
проблемы зависимостей -- оставляем не настроенным
При обработке следующих пакетов произошли ошибки:
mysql-server-5.1
mysql-server
[/console]

/var/log/syslog
[console]
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Feb 15 15:03:23 alfa mysqld_safe[5863]: To do so, start the server, then issue the following commands:
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: /usr/bin/mysqladmin -u root password 'new-password'
Feb 15 15:03:23 alfa mysqld_safe[5863]: /usr/bin/mysqladmin -u root -h alfa password 'new-password'
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: Alternatively you can run:
Feb 15 15:03:23 alfa mysqld_safe[5863]: /usr/bin/mysql_secure_installation
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: which will also give you the option of removing the test
Feb 15 15:03:23 alfa mysqld_safe[5863]: databases and anonymous user created by default. This is
Feb 15 15:03:23 alfa mysqld_safe[5863]: strongly recommended for production servers.
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: See the manual for more instructions.
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5863]: Please report any problems with the /usr/scripts/mysqlbug script!
Feb 15 15:03:23 alfa mysqld_safe[5863]:
Feb 15 15:03:23 alfa mysqld_safe[5909]: 110215 15:03:23 [Note] Plugin 'FEDERATED' is disabled.
Feb 15 15:03:23 alfa mysqld_safe[5909]: 110215 15:03:23 InnoDB: Started; log sequence number 0 44233
Feb 15 15:03:23 alfa mysqld_safe[5909]: 110215 15:03:23 InnoDB: Starting shutdown...
Feb 15 15:03:28 alfa mysqld_safe[5909]: 110215 15:03:28 InnoDB: Shutdown completed; log sequence number 0 44233
Feb 15 15:03:28 alfa mysqld_safe[5928]: 110215 15:03:28 [Note] Plugin 'FEDERATED' is disabled.
Feb 15 15:03:28 alfa mysqld_safe[5928]: 110215 15:03:28 InnoDB: Started; log sequence number 0 44233
Feb 15 15:03:28 alfa mysqld_safe[5928]: 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
Feb 15 15:03:28 alfa mysqld_safe[5928]: 110215 15:03:28 [ERROR] Aborting
Feb 15 15:03:28 alfa mysqld_safe[5928]:
Feb 15 15:03:28 alfa mysqld_safe[5928]: 110215 15:03:28 InnoDB: Starting shutdown...
Feb 15 15:03:34 alfa mysqld_safe[5928]: 110215 15:03:34 InnoDB: Shutdown completed; log sequence number 0 44233
Feb 15 15:03:34 alfa mysqld_safe[5928]: 110215 15:03:34 [Note] /usr/sbin/mysqld: Shutdown complete
Feb 15 15:03:34 alfa mysqld_safe[5928]:
Feb 15 15:03:34 alfa mysqld_safe[5943]: 110215 15:03:34 [Note] Plugin 'FEDERATED' is disabled.
Feb 15 15:03:34 alfa mysqld_safe[5943]: 110215 15:03:34 InnoDB: Started; log sequence number 0 44233
Feb 15 15:03:34 alfa mysqld_safe[5943]: 110215 15:03:34 InnoDB: Starting shutdown...
Feb 15 15:03:39 alfa mysqld_safe[5943]: 110215 15:03:39 InnoDB: Shutdown completed; log sequence number 0 44233
Feb 15 15:03:39 alfa mysqld_safe[5958]: 110215 15:03:39 [Note] Plugin 'FEDERATED' is disabled.
Feb 15 15:03:39 alfa mysqld_safe[5958]: 110215 15:03:39 InnoDB: Started; log sequence number 0 44233
Feb 15 15:03:39 alfa mysqld_safe[5958]: ERROR: 1050 Table 'plugin' already exists
Feb 15 15:03:39 alfa mysqld_safe[5958]: 110215 15:03:39 [ERROR] Aborting
Feb 15 15:03:39 alfa mysqld_safe[5958]:
Feb 15 15:03:39 alfa mysqld_safe[5958]: 110215 15:03:39 InnoDB: Starting shutdown...
Feb 15 15:03:44 alfa mysqld_safe[5958]: 110215 15:03:44 InnoDB: Shutdown completed; log sequence number 0 44233
Feb 15 15:03:44 alfa mysqld_safe[5958]: 110215 15:03:44 [Note] /usr/sbin/mysqld: Shutdown complete
Feb 15 15:03:44 alfa mysqld_safe[5958]:
[/console]

немного погуглил, попробовал вот такой способ:
[console]alfa:~# dpkg-reconfigure --default-priority mysql-server[/console]
выдает:
[console]/usr/sbin/dpkg-reconfigure: Пакет mysql-server сломан или установлен не полностью[/console]

PS: ядро Linux alfa 2.6.32-5-amd64

BaCuJIuu написал:

Переустановили

BaCuJIuu написал:

[console]/etc/init.d/mysql: line 120: /etc/mysql/debian-start: Нет такого файла или каталога[/console]

[console]cat /etc/mysql/debian-start
#!/bin/bash
#
# This script is executed by "/etc/init.d/mysql" on every (re)start.
#
# Changes to this file will be preserved when updating the Debian package.
#

source /usr/share/mysql/debian-start.inc.sh

MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf"
MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="root"

# The following commands should be run when the server is up but in background
# where they do not block the server start and in one shell instance so that
# they run sequentially. They are supposed not to echo anything to stdout.
# If you want to disable the check for crashed tables comment
# "check_for_crashed_tables" out.
# (There may be no output to stdout inside the background process!)
echo "Checking for corrupt, not cleanly closed and upgrade needing tables."
(
upgrade_system_tables_if_necessary;
check_root_accounts;
check_for_crashed_tables;
) >&2 &

exit 0[/console]Есть такой файл?

спс, создал файл, заработало.

у меня такая же проблема и файл создан, но ничего не меняется...