Package: mysql-server-5.1 Version: 5.1.41-3 Severity: normal *** Please type your report below this line ***
I tried the latest version and I still get pretty much (exactly?) the same results. Let me know if you want me to send in some config files. Since I'm rather inexperienced nearly all configs are using default values. I don't remember ever using mysql-server before so it's likely not a scale config file. Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Feb 12 18:01:58 localhost mysqld_safe[6313]: To do so, start the server, then issue the following commands: Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: /usr/bin/mysqladmin -u root password 'new-password' Feb 12 18:01:58 localhost mysqld_safe[6313]: /usr/bin/mysqladmin -u root -h localhost password 'new-password' Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: Alternatively you can run: Feb 12 18:01:58 localhost mysqld_safe[6313]: /usr/bin/mysql_secure_installation Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: which will also give you the option of removing the test Feb 12 18:01:58 localhost mysqld_safe[6313]: databases and anonymous user created by default. This is Feb 12 18:01:58 localhost mysqld_safe[6313]: strongly recommended for production servers. Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: See the manual for more instructions. Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: Please report any problems with the /usr/scripts/mysqlbug script! Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6313]: The latest information about MySQL is available at http://www.mysql.com/ Feb 12 18:01:58 localhost mysqld_safe[6313]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Feb 12 18:01:58 localhost mysqld_safe[6313]: Feb 12 18:01:58 localhost mysqld_safe[6359]: 100212 18:01:58 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:01:58 localhost mysqld_safe[6359]: 100212 18:01:58 InnoDB: Started; log sequence number 0 44233 Feb 12 18:01:58 localhost mysqld_safe[6359]: 100212 18:01:58 InnoDB: Starting shutdown... Feb 12 18:01:59 localhost mysqld_safe[6359]: 100212 18:01:59 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:00 localhost mysqld_safe[6407]: 100212 18:02:00 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:00 localhost mysqld_safe[6407]: 100212 18:02:00 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:00 localhost mysqld_safe[6407]: 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 12 18:02:00 localhost mysqld_safe[6407]: 100212 18:02:00 [ERROR] Aborting Feb 12 18:02:00 localhost mysqld_safe[6407]: Feb 12 18:02:00 localhost mysqld_safe[6407]: 100212 18:02:00 InnoDB: Starting shutdown... Feb 12 18:02:02 localhost mysqld_safe[6407]: 100212 18:02:02 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:02 localhost mysqld_safe[6407]: 100212 18:02:02 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:02 localhost mysqld_safe[6407]: Feb 12 18:02:02 localhost mysqld_safe[6427]: 100212 18:02:02 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:02 localhost mysqld_safe[6427]: 100212 18:02:02 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:02 localhost mysqld_safe[6427]: 100212 18:02:02 InnoDB: Starting shutdown... Feb 12 18:02:03 localhost mysqld_safe[6427]: 100212 18:02:03 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:03 localhost mysqld_safe[6447]: 100212 18:02:03 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:03 localhost mysqld_safe[6447]: 100212 18:02:03 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:03 localhost mysqld_safe[6447]: ERROR: 1050 Table 'plugin' already exists Feb 12 18:02:03 localhost mysqld_safe[6447]: 100212 18:02:03 [ERROR] Aborting Feb 12 18:02:03 localhost mysqld_safe[6447]: Feb 12 18:02:03 localhost mysqld_safe[6447]: 100212 18:02:03 InnoDB: Starting shutdown... Feb 12 18:02:04 localhost mysqld_safe[6447]: 100212 18:02:04 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:04 localhost mysqld_safe[6447]: 100212 18:02:04 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:04 localhost mysqld_safe[6447]: Feb 12 18:02:05 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 [ERROR] Do you already have another mysqld server running on port: 3306 ? Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 [ERROR] Aborting Feb 12 18:02:05 localhost mysqld: Feb 12 18:02:05 localhost mysqld: 100212 18:02:05 InnoDB: Starting shutdown... Feb 12 18:02:06 localhost mysqld: 100212 18:02:06 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:06 localhost mysqld: 100212 18:02:06 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:06 localhost mysqld: Feb 12 18:02:06 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Feb 12 18:02:19 localhost /etc/init.d/mysql[6873]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 12 18:02:19 localhost /etc/init.d/mysql[6873]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 12 18:02:19 localhost /etc/init.d/mysql[6873]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 12 18:02:19 localhost /etc/init.d/mysql[6873]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Feb 12 18:02:19 localhost /etc/init.d/mysql[6873]: Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Feb 12 18:02:21 localhost mysqld_safe[6960]: To do so, start the server, then issue the following commands: Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: /usr/bin/mysqladmin -u root password 'new-password' Feb 12 18:02:21 localhost mysqld_safe[6960]: /usr/bin/mysqladmin -u root -h localhost password 'new-password' Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: Alternatively you can run: Feb 12 18:02:21 localhost mysqld_safe[6960]: /usr/bin/mysql_secure_installation Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: which will also give you the option of removing the test Feb 12 18:02:21 localhost mysqld_safe[6960]: databases and anonymous user created by default. This is Feb 12 18:02:21 localhost mysqld_safe[6960]: strongly recommended for production servers. Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: See the manual for more instructions. Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: Please report any problems with the /usr/scripts/mysqlbug script! Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[6960]: The latest information about MySQL is available at http://www.mysql.com/ Feb 12 18:02:21 localhost mysqld_safe[6960]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Feb 12 18:02:21 localhost mysqld_safe[6960]: Feb 12 18:02:21 localhost mysqld_safe[7005]: 100212 18:02:21 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:21 localhost mysqld_safe[7005]: 100212 18:02:21 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:21 localhost mysqld_safe[7005]: 100212 18:02:21 InnoDB: Starting shutdown... Feb 12 18:02:22 localhost mysqld_safe[7005]: 100212 18:02:22 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:22 localhost mysqld_safe[7035]: 100212 18:02:22 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:22 localhost mysqld_safe[7035]: 100212 18:02:22 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:22 localhost mysqld_safe[7035]: 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 12 18:02:22 localhost mysqld_safe[7035]: 100212 18:02:22 [ERROR] Aborting Feb 12 18:02:22 localhost mysqld_safe[7035]: Feb 12 18:02:22 localhost mysqld_safe[7035]: 100212 18:02:22 InnoDB: Starting shutdown... Feb 12 18:02:24 localhost mysqld_safe[7035]: 100212 18:02:24 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:24 localhost mysqld_safe[7035]: 100212 18:02:24 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:24 localhost mysqld_safe[7035]: Feb 12 18:02:24 localhost mysqld_safe[7055]: 100212 18:02:24 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:24 localhost mysqld_safe[7055]: 100212 18:02:24 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:24 localhost mysqld_safe[7055]: 100212 18:02:24 InnoDB: Starting shutdown... Feb 12 18:02:25 localhost mysqld_safe[7055]: 100212 18:02:25 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:25 localhost mysqld_safe[7075]: 100212 18:02:25 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:25 localhost mysqld_safe[7075]: 100212 18:02:25 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:25 localhost mysqld_safe[7075]: ERROR: 1050 Table 'plugin' already exists Feb 12 18:02:25 localhost mysqld_safe[7075]: 100212 18:02:25 [ERROR] Aborting Feb 12 18:02:25 localhost mysqld_safe[7075]: Feb 12 18:02:25 localhost mysqld_safe[7075]: 100212 18:02:25 InnoDB: Starting shutdown... Feb 12 18:02:26 localhost mysqld_safe[7075]: 100212 18:02:26 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:26 localhost mysqld_safe[7075]: 100212 18:02:26 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:26 localhost mysqld_safe[7075]: Feb 12 18:02:26 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 [Note] Plugin 'FEDERATED' is disabled. Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 InnoDB: Started; log sequence number 0 44233 Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 [ERROR] Do you already have another mysqld server running on port: 3306 ? Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 [ERROR] Aborting Feb 12 18:02:26 localhost mysqld: Feb 12 18:02:26 localhost mysqld: 100212 18:02:26 InnoDB: Starting shutdown... Feb 12 18:02:28 localhost mysqld: 100212 18:02:28 InnoDB: Shutdown completed; log sequence number 0 44233 Feb 12 18:02:28 localhost mysqld: 100212 18:02:28 [Note] /usr/sbin/mysqld: Shutdown complete Feb 12 18:02:28 localhost mysqld: Feb 12 18:02:28 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Feb 12 18:02:41 localhost /etc/init.d/mysql[7497]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Feb 12 18:02:41 localhost /etc/init.d/mysql[7497]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Feb 12 18:02:41 localhost /etc/init.d/mysql[7497]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Feb 12 18:02:41 localhost /etc/init.d/mysql[7497]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Feb 12 18:02:41 localhost /etc/init.d/mysql[7497]: -- System Information: Debian Release: squeeze/sid APT prefers testing APT policy: (900, 'testing'), (800, 'unstable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32-trunk-amd64 (SMP w/2 CPU cores) Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages mysql-server-5.1 depends on: ii adduser 3.112 add and remove users and groups ii debconf [debconf-2.0] 1.5.28 Debian configuration management sy ii libc6 2.10.2-2 GNU C Library: Shared libraries ii libdbi-perl 1.609-1 Perl Database Interface (DBI) ii libgcc1 1:4.4.2-9 GCC support library ii libmysqlclient16 5.1.41-3 MySQL database client library ii libstdc++6 4.4.2-9 The GNU Standard C++ Library v3 ii libwrap0 7.6.q-18 Wietse Venema's TCP wrappers libra ii lsb-base 3.2-23 Linux Standard Base 3.2 init scrip ii mysql-client-5.1 5.1.41-3 MySQL database client binaries ii mysql-common 5.1.41-3 MySQL database common files (e.g. ii passwd 1:4.1.4.2-1 change and administer password and ii perl 5.10.1-9 Larry Wall's Practical Extraction ii psmisc 22.10-1 utilities that use the proc file s ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime Versions of packages mysql-server-5.1 recommends: ii heirloom-mailx [mailx] 12.4-1.1+b1 feature-rich BSD mail(1) ii libhtml-template-perl 2.9-1 HTML::Template : A module for usin Versions of packages mysql-server-5.1 suggests: pn tinyca <none> (no description available) -- debconf information: mysql-server/error_setting_password: mysql-server-5.1/start_on_boot: true mysql-server-5.1/postrm_remove_databases: false mysql-server-5.1/nis_warning: mysql-server-5.1/really_downgrade: false * mysql-server/password_mismatch: mysql-server/no_upgrade_when_using_ndb: -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
