Your message dated Thu, 12 Apr 2012 22:21:12 +0100
with message-id <[email protected]>
and subject line Re: [debian-mysql] Bug#512309: debian-sys-maint has
insufficient permissions on MySQL 5.0
has caused the Debian Bug report #512309,
regarding debian-sys-maint has insufficient permissions on MySQL 5.0
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
512309: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=512309
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Thomas,
Someone moved all the bugs from old mysql packages onto the latest. So
now we have to triage an extra hundred or so bugs to find the few that
are still relevant. I could not see it as an issue but the changelog was
not clear. Thanks for the quick response.
On 12/04/12 22:05, Thomas Gelf wrote:
Well... that's amazing. The "this-is-not-a-bug"-answer for this bug
request has been posted within less than a day. After explaining WHY
this is should be considered an issue and some confirmations from other
people affected by this behaviour it took less than four years to
finally get the liberating "is-this-still-an-issue" reply.
Thank you, Nicholas. And no, it isn't an issue anymore - it has been
fixed in the meantime. Please note that this bug has been reported for
Debian Sarge, that's the one we have had once upon a time, long before
Lenny and even longer before Squeeze...
Regards,
Thomas Gelf
--- End Message ---
