Bug #16297 In memory grant tables not flushed when users's hostname is ""
| Submitted: | 9 Jan 2006 10:30 | Modified: | 9 Jun 2006 16:15 |
|---|---|---|---|
| Reporter: | Magnus Blåudd | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.19 | OS: | |
| Assigned to: | Magnus Blåudd | CPU Architecture: | Any |
[3 Feb 2006 13:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/2127
[3 Feb 2006 14:35]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/2130
[23 May 2006 9:35]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/6760
[29 May 2006 13:23]
Magnus Blåudd
Pushed to 5.0-maint
[7 Jun 2006 9:28]
Magnus Blåudd
Pushed to 5.0.23 and 5.1.12, fixes and testcases for creating and manipulating users and grant when the user is something like mysqltest_8@'' or mysqltest_8
[9 Jun 2006 16:15]
Paul DuBois
Noted in 5.0.23, 5.1.12 changelogs. Grant table modifications sometimes did not refresh the in-memory tables if the hostname was '' or not specified.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.044 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: create user mysqltest_7@; set password for mysqltest_7@ = password('systpass'); show grants for mysqltest_7@; drop user mysqltest_7@; # This "show grants" should return error saying that user does not exists, but unfortunately user still exists in memory grant tables show grants for mysqltest_7@; The information about database-level privileges is alose kept in memory. How to repeat: See above Suggested fix: Remove the user from the in memory grant structs when dropped. Workaround: - Call "flush privileges" after user has been dropped.