MySQL Bugs: #81301: Hyphens wrongly disallowed in hostnames

Bug #81301	Hyphens wrongly disallowed in hostnames
Submitted:	4 May 2016 5:52	Modified:	27 May 2016 18:22
Reporter:	Nicholas Sherlock	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	6.3.6	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
On the "users and privileges" page, Workbench does not allow hyphens inside hostnames in the "limit to hosts matching" field. 

For example, if I enter the hostname "ip-10-1-1-1.ec2.internal", a red "X" appears next to the field with the tooltip "host name contains incorrect characters", and clicking apply results in a pop-up with the message:

Invalid Host Specification
The host specification "ip-10-1-1-1.ec2.internal" is not valid. Please correct it and try again.

The same hostname works fine when used with a MySQL grant statement:

GRANT ALL PRIVILEGES ON *.* TO 'username'@'ip-10-1-1-1.ec2.internal';
> 0 row(s) affected

How to repeat:
Attempt to enter a hostname which contains a hyphen in the "limit to hosts matching" field on the "users and privileges" page. Workbench will not allow changes to be saved.

Suggested fix:
Hyphens should be allowed in hostnames.

Hello Nicholas,

Thank you for the report and feedback!

Thanks,
Umesh

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

Under Users and Privileges, Workbench did not allow hyphens for host names
in the "limit to hosts matching" field.

Thank you for the bug report.