I'd like to confirm that this also happens with a clean install of pure squeeze (only iceweasel taken from experimental). I tried both mysql-server from squeeze (5.1.37-2) and sid (5.1.39-1).
I have no knowledge on how this all works, I only need it as a kmail dependency (which is quite silly BTW). I didn't sent an upstream bug. Since it's a syntax error the bug is most likely linked to the package itself. mar...@localhost:~$ sudo cat /var/log/syslog | grep mysql Oct 21 01:38:13 localhost mysqld_safe[6640]: 091021 1:38:13 [Warning] Forcing shutdown of 2 plugins Oct 21 01:38:13 localhost mysqld_safe[6640]: 091021 1:38:13 [Warning] Forcing shutdown of 2 plugins Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Oct 21 01:38:13 localhost mysqld_safe[6640]: To do so, start the server, then issue the following commands: Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysqladmin -u root password 'new-password' Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysqladmin -u root -h localhost password 'new-password' Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: Alternatively you can run: Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysql_secure_installation Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: which will also give you the option of removing the test Oct 21 01:38:13 localhost mysqld_safe[6640]: databases and anonymous user created by default. This is Oct 21 01:38:13 localhost mysqld_safe[6640]: strongly recommended for production servers. Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: See the manual for more instructions. Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: Please report any problems with the /usr/scripts/mysqlbug script! Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6640]: The latest information about MySQL is available at http://www.mysql.com/ Oct 21 01:38:13 localhost mysqld_safe[6640]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Oct 21 01:38:13 localhost mysqld_safe[6640]: Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021 1:38:13 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021 1:38:13 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021 1:38:13 InnoDB: Starting shutdown... Oct 21 01:38:14 localhost mysqld_safe[6686]: 091021 1:38:14 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:14 localhost mysqld_safe[6686]: 091021 1:38:14 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021 1:38:15 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021 1:38:15 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:15 localhost mysqld_safe[6738]: 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 Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021 1:38:15 [ERROR] Aborting Oct 21 01:38:15 localhost mysqld_safe[6738]: Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021 1:38:15 InnoDB: Starting shutdown... Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021 1:38:17 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021 1:38:17 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021 1:38:17 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:17 localhost mysqld_safe[6738]: Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021 1:38:17 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021 1:38:17 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021 1:38:17 InnoDB: Starting shutdown... Oct 21 01:38:18 localhost mysqld_safe[6760]: 091021 1:38:18 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:18 localhost mysqld_safe[6760]: 091021 1:38:18 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021 1:38:18 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021 1:38:18 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:18 localhost mysqld_safe[6786]: ERROR: 1050 Table 'plugin' already exists Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021 1:38:18 [ERROR] Aborting Oct 21 01:38:18 localhost mysqld_safe[6786]: Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021 1:38:18 InnoDB: Starting shutdown... Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021 1:38:19 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021 1:38:19 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021 1:38:19 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:19 localhost mysqld_safe[6786]: Oct 21 01:38:19 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Oct 21 01:38:19 localhost mysqld: 091021 1:38:19 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:20 localhost mysqld: 091021 1:38:20 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:20 localhost mysqld: 091021 1:38:20 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address Oct 21 01:38:20 localhost mysqld: 091021 1:38:20 [ERROR] Do you already have another mysqld server running on port: 3306 ? Oct 21 01:38:20 localhost mysqld: 091021 1:38:20 [ERROR] Aborting Oct 21 01:38:20 localhost mysqld: Oct 21 01:38:20 localhost mysqld: 091021 1:38:20 InnoDB: Starting shutdown... Oct 21 01:38:21 localhost mysqld: 091021 1:38:21 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:21 localhost mysqld: 091021 1:38:21 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:21 localhost mysqld: 091021 1:38:21 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:21 localhost mysqld: Oct 21 01:38:21 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: Oct 21 01:38:35 localhost mysqld_safe[7346]: 091021 1:38:35 [Warning] Forcing shutdown of 2 plugins Oct 21 01:38:35 localhost mysqld_safe[7346]: 091021 1:38:35 [Warning] Forcing shutdown of 2 plugins Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Oct 21 01:38:35 localhost mysqld_safe[7346]: To do so, start the server, then issue the following commands: Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysqladmin -u root password 'new-password' Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysqladmin -u root -h localhost password 'new-password' Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: Alternatively you can run: Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysql_secure_installation Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: which will also give you the option of removing the test Oct 21 01:38:35 localhost mysqld_safe[7346]: databases and anonymous user created by default. This is Oct 21 01:38:35 localhost mysqld_safe[7346]: strongly recommended for production servers. Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: See the manual for more instructions. Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: Please report any problems with the /usr/scripts/mysqlbug script! Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7346]: The latest information about MySQL is available at http://www.mysql.com/ Oct 21 01:38:35 localhost mysqld_safe[7346]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Oct 21 01:38:35 localhost mysqld_safe[7346]: Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021 1:38:35 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021 1:38:35 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021 1:38:35 InnoDB: Starting shutdown... Oct 21 01:38:36 localhost mysqld_safe[7397]: 091021 1:38:36 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:36 localhost mysqld_safe[7397]: 091021 1:38:36 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021 1:38:36 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021 1:38:36 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:36 localhost mysqld_safe[7427]: 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 Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021 1:38:36 [ERROR] Aborting Oct 21 01:38:36 localhost mysqld_safe[7427]: Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021 1:38:36 InnoDB: Starting shutdown... Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021 1:38:38 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021 1:38:38 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021 1:38:38 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:38 localhost mysqld_safe[7427]: Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021 1:38:38 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021 1:38:38 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021 1:38:38 InnoDB: Starting shutdown... Oct 21 01:38:39 localhost mysqld_safe[7450]: 091021 1:38:39 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:39 localhost mysqld_safe[7450]: 091021 1:38:39 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021 1:38:39 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021 1:38:39 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:39 localhost mysqld_safe[7473]: ERROR: 1050 Table 'plugin' already exists Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021 1:38:39 [ERROR] Aborting Oct 21 01:38:39 localhost mysqld_safe[7473]: Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021 1:38:39 InnoDB: Starting shutdown... Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021 1:38:40 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021 1:38:40 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021 1:38:40 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:40 localhost mysqld_safe[7473]: Oct 21 01:38:40 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Oct 21 01:38:40 localhost mysqld: 091021 1:38:40 [Note] Plugin 'FEDERATED' is disabled. Oct 21 01:38:41 localhost mysqld: 091021 1:38:41 InnoDB: Started; log sequence number 0 44233 Oct 21 01:38:41 localhost mysqld: 091021 1:38:41 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address Oct 21 01:38:41 localhost mysqld: 091021 1:38:41 [ERROR] Do you already have another mysqld server running on port: 3306 ? Oct 21 01:38:41 localhost mysqld: 091021 1:38:41 [ERROR] Aborting Oct 21 01:38:41 localhost mysqld: Oct 21 01:38:41 localhost mysqld: 091021 1:38:41 InnoDB: Starting shutdown... Oct 21 01:38:42 localhost mysqld: 091021 1:38:42 InnoDB: Shutdown completed; log sequence number 0 44233 Oct 21 01:38:42 localhost mysqld: 091021 1:38:42 [Warning] Forcing shutdown of 1 plugins Oct 21 01:38:42 localhost mysqld: 091021 1:38:42 [Note] /usr/sbin/mysqld: Shutdown complete Oct 21 01:38:42 localhost mysqld: Oct 21 01:38:42 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
