MySQL Bugs: #75008: Installation with specified root password fails and multiplicates error messages

Bug #75008	Installation with specified root password fails and multiplicates error messages
Submitted:	26 Nov 2014 10:33	Modified:	4 Dec 2017 23:05
Reporter:	Andrii Muliar	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.6.21	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	log

Description:
Installation with specified root password c;)YETd&M4]UtG5 fails on Starting Server step. 
Additionally:
1) log tab shows botched root password,
2) log messages appear multiplicated after every Retry.

How to repeat:
1. Start installing MySQL Server 5.6.21
2. Enter root password: c;)YETd&M4]UtG5
3. Follow steps until Apply Server Configuration
4. Press Retry several times after error message appears: "Configuration for MySQL Server 5.6.21 has failed. You can find more information about the configuration steps taken and what failed by looking at the 'Log' tab.".

Suggested fix:
1) Either add validation for root password or allow to set passwords with special symbols.
2) Fix multiplication of logging messages.
3) Do not show root password in log.

Log messages from Log tab.

Attachment: MySQL_ApplyServerConfiguration.txt (text/plain), 5.10 KiB.

Failed

Attachment: configuration_failed.png (image/png, text), 48.49 KiB.

Thank you for the bug report.

MySQL Server 5.7.7 (x64), community web installer.

I generated a root password, which happens to end with the following characters: "rj?;" (without the "quotes"). So it seems to break on the semicolon character ;

Now I'm stuck in the same screen that the reporter of this bug has included an image of. Configuration step "Starting Server" fails. No way to go back. I can only click 'Finish' - thereby skipping the last three steps.

Still actual while installing version 5.7.9. No complaints about invalid characters in the root password, no hints that semicolons may not be used in passwords, no option to step back from the configuration if it fails on Starting Server. The only possibility to fix the installation is to remove and repeat it.

Previously while Installer was performing Starting Server configuration step,
it tried to connect to MySQL Server but error was raised because password
provided by user contained special characters like ';' and Installer did not
correctly format passwords for this step.
 
With this fix, password is formatted correctly so it could connect
successfully to MySQL Server during Starting Server step and continue with
the next configuration steps.

Fixed as of the upcoming MySQL Installer 1.4.21 release, and here's the changelog entry:

Passwords that contained special characters such as semicolons (;) were
improperly formatted before the password was sent to the server, resulting
in an error during the server configuration step.

Thank you for the bug report.