[debian-mysql] Bug#776207: mysql-server-core-5.5: SQL syntax error while updating mysql.user table

Olaf van der Spek olaf at xwis.net
Sun Jan 25 12:49:52 UTC 2015


Package: mysql-server-core-5.5
Version: 5.5.41-0+wheezy1
Severity: normal

Hi,

Not sure what's going on here:
Jan 24 13:12:15 xwis mysqld_safe[6010]: 150124 13:12:15 InnoDB: 5.5.41 started; log sequence number 13655283
Jan 24 13:12:15 xwis mysqld_safe[6010]: 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
Jan 24 13:12:15 xwis mysqld_safe[6010]: 150124 13:12:15 [ERROR] Aborting
Jan 24 13:12:15 xwis mysqld_safe[6010]: 
Jan 24 13:12:15 xwis mysqld_safe[6010]: 150124 13:12:15  InnoDB: Starting shutdown...

BTW, MySQL is quite noisy w.r.t. syslog.

Greetings,

Olaf

-- System Information:
Debian Release: 7.8
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.8.13-xxxx-grs-ipv6-64 (SMP w/4 CPU cores)
Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-core-5.5 depends on:
ii  libaio1     0.3.109-3
ii  libc6       2.13-38+deb7u6
ii  libgcc1     1:4.7.2-5
ii  libstdc++6  4.7.2-5
ii  libwrap0    7.6.q-24
ii  zlib1g      1:1.2.7.dfsg-13

mysql-server-core-5.5 recommends no packages.

mysql-server-core-5.5 suggests no packages.

-- no debconf information



More information about the pkg-mysql-maint mailing list