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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org