Bug #95352 The installer does not handle single quotes in the root password correctly
Submitted: 13 May 2019 10:53 Modified: 5 Jun 2023 17:31
Reporter: Ajit Dhaliwal Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any

[13 May 2019 10:53] Ajit Dhaliwal
Description:
Please see the problem description with screen shots here https://stackoverflow.com/questions/55916949/log-in-problems-with-mysql-8-0-16-on-windows-...

Basically when using the installer I entered a Root account password that uses a single quote. When trying to use this the installer does not escape the single quote properly and we are locked out of the server. At no point does the installer complain about the password.

How to repeat:
Use a single quote in the Root password when using the installer on Windows.

Suggested fix:
Escape the single quotes correctly
[20 Jul 2019 23:17] MySQL Verification Team
Thank you for the bug report. Please print here a sample password which it fails?. Thanks.
[21 Jul 2019 8:36] Ajit Dhaliwal
An example password which will fail in the context mentioned is 

abcdefg'hijk
[21 Jul 2019 21:06] MySQL Verification Team
Thank you for the feedback.
[13 Sep 2021 12:58] MySQL Verification Team
Bug #104861 marked as duplicate of this one.
[6 Jul 2022 12:19] MySQL Verification Team
Bug #106823 marked as duplicate of this one.
[22 Feb 2023 19:26] Jose Ramirez Ruiz
Posted by developer:
 
Single quotes are now supported as part of a password. All characters supported by default on MySQL Server are now supported.