[debian-mysql] Bug#512309: mysql-server: this problem also breaks backupping of databases with views

[martin sarsale]

Package: mysql-server
Version: 5.0.51a-24+lenny1
Followup-For: Bug #512309

Reported as a bug for automysqlbackup but moved here by maintainer's suggestion:


When a database has a view, automysqlbackup fails because debian-sys-maint at localhost do not has permissions to "show view"

ERROR 1142 (42000): SHOW VIEW command denied to user 'debian-sys-maint'@'localhost' for table 'geonames_custom_names'


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

Kernel: Linux 2.6.26-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server depends on:
ii  mysql-server-5.0       5.0.51a-24+lenny1 MySQL database server binaries

mysql-server recommends no packages.

mysql-server suggests no packages.

-- no debconf information