Bug #25308 Adding a user requires redundant privileges
Submitted: 28 Dec 2006 11:18 Modified: 28 Jan 2007 11:55
Reporter: Rickard Andersson Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.2.8 OS:
Assigned to: CPU Architecture:Any
Tags: add user privileges

[28 Dec 2006 11:18] Rickard Andersson 
Description:
Adding a new user as a non-root user requires redundant privileges and throws various exceptions. CREATE USER and GRANT should be enough, but it isn't. It appears as if we need SELECT, UPDATE, INSERT and DELETE permissions on the mysql table. There might be other permissions needed as well, but frankly, it's such a pain to debug that I couldn't be bothered.

How to repeat:
1. Add a new user with the global permissions CREATE USER and GRANT.
2. Login as this user.
3. Try to create and edit users.
[28 Dec 2006 11:55] Valeriy Kravchuk 
Thank you for a problem report. As you set MySQL Administrator category, do you mean that same actions that work in mysql command line client do not work in MySQL Administrator? If so, please, send a complete set of statements/actions that demonstrates the problem in MySQL Administrator.

Note also that according to http://dev.mysql.com/doc/refman/5.0/en/grant.html there is no "GRANT" privilege in MySQL. You can GRANT some privilege with GRANT OPTION.
[29 Jan 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".