Bug 113960 - [PATCH] Bug fix + enhancement for mysql_setpermission
[PATCH] Bug fix + enhancement for mysql_setpermission
Status: CLOSED ERRATA
Product: Red Hat Enterprise Linux 3
Classification: Red Hat
Component: mysql (Show other bugs)
3.0
All Linux
low Severity medium
: ---
: ---
Assigned To: Tom Lane
David Lawrence
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2004-01-20 12:39 EST by Chris Adams
Modified: 2013-07-02 23:00 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2004-03-16 20:32:48 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
bug fix and enhancement for mysql_setpermission command (3.74 KB, patch)
2004-01-20 12:39 EST, Chris Adams
no flags Details | Diff

  None (edit)
Description Chris Adams 2004-01-20 12:39:08 EST
There is a bug in mysql_setpermission that it does not flush the
privilege tables after changing a user's password.  The one-liner fix
is to flush privileges.

There is no nice command to remove a database and the associated
users, so I wrote an addition to mysql_setpermission that does just
that.  It is not real pretty, but I tried to stay (more or less) with
the original code "style".

I have not gone upstream with this patch, since I know (barring a
licensing change on MySQL) we won't be seeing MySQL 4 or higher in a
Red Hat release.

Here's a patch with the above bug fix and enhancement.
Comment 1 Chris Adams 2004-01-20 12:39:46 EST
Created attachment 97131 [details]
bug fix and enhancement for mysql_setpermission command
Comment 2 Tom Lane 2004-03-16 15:35:55 EST
I'm going to apply the password flush fix for FC2, since it's clearly
a bug.  I'm not too excited about local enhancements though --- I'd
suggest submitting that part of the patch to MySQL AB.  One hopes
they'll eventually come to their senses about the licensing mess and
patch their license to allow us to ship MySQL 4.*.
Comment 3 Tom Lane 2004-03-16 20:32:48 EST
Patch is applied in mysql-3.23.58-8 for Fedora Core 2.
Comment 4 Josh Bressers 2004-10-20 15:12:43 EDT
An errata has been issued which should help the problem 
described in this bug report. This report is therefore being 
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files, 
please follow the link below. You may reopen this bug report 
if the solution does not work for you.

http://rhn.redhat.com/errata/RHSA-2004-597.html
Comment 5 Josh Bressers 2004-10-20 15:41:27 EDT
An errata has been issued which should help the problem 
described in this bug report. This report is therefore being 
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files, 
please follow the link below. You may reopen this bug report 
if the solution does not work for you.

http://rhn.redhat.com/errata/RHSA-2004-569.html

Note You need to log in before you can comment on or make changes to this bug.