MySQL Bugs: #50761: Users should have separate Name and Host textboxes

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:	None
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

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

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.

Screenshot of workbench

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

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.

Thank you for the clarification.