Bug #112563 Could not create a user by Limit to Hosts Matching error
Submitted: 28 Sep 2023 13:35 Modified: 17 Oct 2023 11:54
Reporter: Yauheni Kisel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.33 OS:MacOS (13.6 (22G120))
Assigned to: CPU Architecture:ARM

[28 Sep 2023 13:35] Yauheni Kisel
Description:
Hello!

It's not possible to create a user through Users and Privileges -> Add Account with the Limit to Hosts Matching like the string:

my-host-name-%.my.domain.name.example.com 

It shows the error:

"Invalid host specification

The host specification "my-host-name-%%.my.domain.name.example.com " is not valid. Please correct it and try again.
"

Workbench allows to create a user only with '%' Host Matching.
Interesting that it doubles "%" in the error message.

How to repeat:
Install MySQL Workbench 8.0.33 to Mac and try to create a mysql user in a database through 
Users and Privileges -> Add Account with these:

Login Name: any
Limit to Hosts Matching: my-host-name-%.my.domain.name.example.com (use any string which includes %)
Password: any
[17 Oct 2023 11:54] MySQL Verification Team
Hello Yauheni Kisel,

Thank you for the bug report.
Imho this is duplicate of Bug #92333, please see Bug #92333.

Regards,
Ashwini Patil