Bug #100437 Unable to create usernames that require escaping as in `otherwise invalid`
Submitted: 5 Aug 2020 18:23 Modified: 20 Aug 2020 11:13
Reporter: David Greenwood Email Updates:
Status: Verified Impact on me:
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:8 OS:Windows
Assigned to: CPU Architecture:Any

[5 Aug 2020 18:23] David Greenwood
When adding a new user to a MySQL instance in MySQL for Windows: Installer, it is not possible to escape a username containing characters that are otherwise invalid. 

There is seemingly no way to escape such a username, yet the MySQL grammar permits such usernames when they are escaped, e.g. 

CREATE USER `invalid-username-with-dashes`@`%` IDENTIFIED BY 'password';

The installer appears not to conform to the grammar in this instance.

How to repeat:
Run the installer and create a new MySQL instance. At the page where users can be added, bring up the dialog for adding a user. Type a username that would require escaping in SQL. Try to add the user. The installer does not permit it. Try to escape the invalid username using `` as in `something-invalid.` Again, the installer does not accept the input.

Suggested fix:
Allow use of `` around the username input.
[20 Aug 2020 11:13] MySQL Verification Team
Hello David Greenwood,

Thank you for the reasonable feature request.!

Ashwini Patil