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

[13 May 2019 10:53] Ajit Dhaliwal
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 

[21 Jul 2019 21:06] MySQL Verification Team
Thank you for the feedback.