Bug #50761 Users should have separate Name and Host textboxes
Submitted: 30 Jan 2010 21:23 Modified: 2 Feb 2010 17:12
Reporter: Chris Van Vranken Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.15 OSS Rev 5053 OS:Windows
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: host, users

[30 Jan 2010 21:23] Chris Van Vranken
When creating a user object in mysql workbench there is only a name textbox.  If one types in the username as 'user'@'host' it generates the grant commands properly.  If one does not realize that quotes are needed around user and host the grant commands fail, or if one is unfamiliar with the syntax of the commands then it can take some research to understand what is needed to use the User objects.

How to repeat:
Create a user object, but do not supply the quotes.  The grant commands will fail when you forward engineer the objects with privileges from roles.  (may need to use wildcards to cause it to fail.)

Suggested fix:
Create another textbox for the host information.  And give a descritpion of the % and _ wildcards next to it.  Then when the grant commands are generated automatically enclose the given hostname and username in quotes, but make sure that if quotes were supplied only one set of quotes is generated.
[2 Feb 2010 12:46] Alfredo Kojima
I'm not sure I understand this.
1st, there is a separate textbox for the host, although the caption says "Limit Connectivity to Hosts Matching:".
2nd, you must not put quotes in any of the text boxes.
[2 Feb 2010 17:10] Chris Van Vranken
Screenshot of workbench

Attachment: UserObjectTextboxes.jpg (image/jpeg, text), 108.47 KiB.

[2 Feb 2010 17:12] Chris Van Vranken
I think it may be that we are looking in two different places within workbench. Please take a look at the screenshot I just attached to the bug.
[2 Feb 2010 17:17] Alfredo Kojima
Thank you for the clarification.