Removing the 'skip-federated' option from /etc/mysql/my.cnf does not resolve the problem for me - the server still fails to start. However, the option has influence on what is written to the /var/log/daemon.log.
The daemon.log with the 'skip-federated' option set: Aug 13 22:06:42 localhost mysqld_safe[4051]: started Aug 13 22:06:42 localhost mysqld[4054]: 090813 22:06:42 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated' Aug 13 22:06:42 localhost mysqld[4054]: Aug 13 22:06:42 localhost mysqld_safe[4057]: ended Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: The daemon.log without the 'skip-federated' option: Aug 13 22:11:02 localhost mysqld_safe[4531]: started Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: The first specified data file ./ibdata1 did not exist: Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: a new database to be created! Aug 13 22:11:02 localhost mysqld[4534]: 090813 22:11:02 InnoDB: Setting file ./ibdata1 size to 10 MB Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait... Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03 InnoDB: Log file ./ib_logfile0 did not exist: new to be created Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait... Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03 InnoDB: Log file ./ib_logfile1 did not exist: new to be created Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait... Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Doublewrite buffer not found: creating new Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Doublewrite buffer created Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Creating foreign key constraint system tables Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Foreign key constraint system tables created Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03 InnoDB: Started; log sequence number 0 0 Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Aug 13 22:11:03 localhost mysqld_safe[4545]: ended Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: I've just installed the mysql-server because of that dumb dependency of kaddressbook on it, so it was a clean MySQL installation on my system. The version is 5.0.51a-24+lenny1 (current from testing) -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
