[debian-mysql] Bug#512309: debian-sys-maint has insufficient permissions on MySQL 5.0

[Thomas Gelf]

Package: mysql-server-5.0
Version: 5.0.51a-21

The user debian-sys-maint is created by mysql-server-5.0.postinst,
however it does not get all available permissions and is therefore
not able to run queries like:

GRANT ALL PRIVILEGES ON *.* TO 'ab'@'127.0.0.1' IDENTIFIED BY 'yx';

You can fix this on an existing Debian installation by running:

echo "UPDATE user SET Create_view_priv = 'Y', Show_view_priv = 'Y', \
 Create_routine_priv = 'Y', Alter_routine_priv = 'Y', \
 Create_user_priv = 'Y' WHERE User = 'debian-sys-maint'; \
FLUSH PRIVILEGES; \
" | mysql --defaults-extra-file=/etc/mysql/debian.cnf mysql

mysql-server-5.0.postinst should be changed to set correct permissions,
and preferrably also take care to fix permissions on upgrade on systems
with debian-sys-maint.

Best regards,
Thomas Gelf