[debian-mysql] Bug#545751: Still doesn't work for me

Marcin Trybus mtrybus at o2.pl
Fri Feb 12 17:20:32 UTC 2010 

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:

More information about the pkg-mysql-maint mailing list