Bug #7905 Creating user with GRANT fails with password but works without
| Submitted: | 14 Jan 2005 13:31 | Modified: | 19 Mar 2005 11:45 |
|---|---|---|---|
| Reporter: | Hartmut Holzgraefe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.1.8 | OS: | Linux (linux) |
| Assigned to: | Jani Tolonen | CPU Architecture: | Any |
[14 Jan 2005 13:31]
Hartmut Holzgraefe
[14 Mar 2005 14:57]
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/internals/23002
[17 Mar 2005 6:15]
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/internals/23126
[19 Mar 2005 11:45]
Jani Tolonen
Improved error message in 4.1. Fixed in 5.0, following the new logic: # If you have GRANT OPTION to a database, but no privileges to mysql privilege database, you can only grant privileges to already existing users. You will not be able to change passwords for other users. # If you have UPDATE privilege to mysql database, you can also change passwords for other users. UPDATE privilege does not give you right to create any user. # If you have INSERT privilege to mysql database, you can create new users with or without password. INSERT privilege does not give you right to modify an existing user. # If you have GRANT privilege to mysql database, you can modify existing users or create new ones.
[20 Apr 2006 12:38]
Steven Hartland
Is this fix going to be back ported to 4.0 as we are currently unable to upgrade and have this very issue?
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 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.