[debian-mysql] Bug#444107: mysql server failed to start

[YuGiOhJCJ]

Package: mysql-server-5.0
Version: 5.0.51a-24+lenny4

I think I get the same problem.
When I try to install `mysql-server-5.0', I get an error:
---
$ sudo apt-get install mysql-server-5.0
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server-5.0
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/26.7MB of archives.
After this operation, 83.8MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 134974 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-24+lenny4_i386.deb) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
---

When I watch my /var/log/syslog file I see some errors:

---
16:23:58mysqld_safe[24279]: 101009 16:23:58 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
16:23:58mysqld_safe[24279]: 
16:23:58mysqld_safe[24279]: Installation of system tables failed!
16:23:58mysqld_safe[24279]: 
16:23:58mysqld_safe[24279]: Examine the logs in /var/lib/mysql for more information.
16:23:58mysqld_safe[24279]: You can try to start the mysqld daemon with:
16:23:58mysqld_safe[24279]: /usr/sbin/mysqld --skip-grant &
16:23:58mysqld_safe[24279]: and use the command line tool
16:23:58mysqld_safe[24279]: /usr/bin/mysql to connect to the mysql
16:23:58mysqld_safe[24279]: database and look at the grant tables:
16:23:58mysqld_safe[24279]: 
16:23:58mysqld_safe[24279]: shell> /usr/bin/mysql -u root mysql
16:23:58mysqld_safe[24279]: mysql> show tables
16:23:58mysqld_safe[24279]: 
16:23:58mysqld_safe[24279]: Try 'mysqld --help' if you have problems with paths. Using --log
16:23:58mysqld_safe[24279]: gives you a log in /var/lib/mysql that may be helpful.
16:23:58mysqld_safe[24279]: 
16:23:58mysqld_safe[24279]: The latest information about MySQL is available on the web at
16:23:58mysqld_safe[24279]: http://www.mysql.com
16:23:58mysqld_safe[24279]: Please consult the MySQL manual section: 'Problems running mysql_install_db',
16:23:58mysqld_safe[24279]: and the manual section that describes problems on your OS.
16:23:58mysqld_safe[24279]: Another information source is the MySQL email archive.
16:23:58mysqld_safe[24279]: Please check all of the above before mailing us!
16:23:58mysqld_safe[24279]: And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
16:23:58mysqld_safe[24310]: 101009 16:23:58 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
16:23:58mysqld_safe[24310]: 
16:23:58mysqld_safe[24318]: 101009 16:23:58 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
16:23:58mysqld_safe[24318]: 
16:23:58mysqld_safe[24322]: 101009 16:23:58 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
16:23:58mysqld_safe[24322]: 
16:23:58mysqld_safe[24326]: 101009 16:23:58 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
16:23:58mysqld_safe[24326]: 
16:23:58mysqld_safe[24405]: started
16:23:58mysqld[24408]: InnoDB: The first specified data file ./ibdata1 did not exist:
16:23:58mysqld[24408]: InnoDB: a new database to be created!
16:23:58mysqld[24408]: 101009 16:23:58  InnoDB: Setting file ./ibdata1 size to 10 MB
16:23:58mysqld[24408]: InnoDB: Database physically writes the file full: wait...
16:23:59mysqld[24408]: 101009 16:23:59  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
16:23:59mysqld[24408]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
16:23:59mysqld[24408]: InnoDB: Database physically writes the file full: wait...
16:23:59mysqld[24408]: 101009 16:23:59  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
16:23:59mysqld[24408]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
16:23:59mysqld[24408]: InnoDB: Database physically writes the file full: wait...
16:23:59mysqld[24408]: InnoDB: Doublewrite buffer not found: creating new
16:23:59mysqld[24408]: InnoDB: Doublewrite buffer created
16:23:59mysqld[24408]: InnoDB: Creating foreign key constraint system tables
16:23:59mysqld[24408]: InnoDB: Foreign key constraint system tables created
16:23:59mysqld[24408]: 101009 16:23:59  InnoDB: Started; log sequence number 0 0
16:23:59mysqld[24408]: 101009 16:23:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
16:23:59mysqld_safe[24418]: ended
16:24:13/etc/init.d/mysql[24553]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
16:24:13/etc/init.d/mysql[24553]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
16:24:13/etc/init.d/mysql[24553]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
16:24:13/etc/init.d/mysql[24553]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
16:24:13/etc/init.d/mysql[24553]:
---

I don't know what is the reason of this error but maybe you can help me to find why it failed.

I am using Debian GNU/Linux "lenny".