Bug 113960 – [PATCH] Bug fix + enhancement for mysql_setpermission

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 113960 - [PATCH] Bug fix + enhancement for mysql_setpermission

Summary:	[PATCH] Bug fix + enhancement for mysql_setpermission

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Linux 3
Classification:	Red Hat
Component:	mysql (Show other bugs)
Sub Component:
Version:	3.0
Hardware:	All Linux

Priority	low Severity medium
Target Milestone:	---
Target Release:	---
Assigned To:	Tom Lane
QA Contact:	David Lawrence
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2004-01-20 12:39 EST by Chris Adams
Modified:	2013-07-02 23:00 EDT (History)
CC List:	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
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Red Hat Product Errata	RHSA-2004:569	normal	SHIPPED_LIVE	Low: mysql security update	2004-10-20 00:00:00 EDT
Red Hat Product Errata	RHSA-2004:597	normal	SHIPPED_LIVE	Important: mysql security update	2004-10-20 00:00:00 EDT

Groups: 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.