MySQL Bugs: #64219: Syntax Error on Config Password while Using Windows Installer

Bug #64219	Syntax Error on Config Password while Using Windows Installer
Submitted:	3 Feb 2012 9:08	Modified:	13 Jan 2015 8:30
Reporter:	田生	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S3 (Non-critical)
Version:	5.5.20.0	OS:	Windows (7 32bit)
Assigned to:		CPU Architecture:	Any
Tags:	password, syntax error, Windows installer

Description:
Installer show syntax error during config password if the password contained certen chars.

How to repeat:
When the installer ask for root's password, typed "',.pyf" (without "").
The installer report:
  mysql-server-5.5-win32:100 - Unable to update security settings. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.pyf') WHERE User='root'' at line 1

What exact version of installer is it, 5.5.20?

mysql-installer-5.5.20.0.msi
download from
http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-5.5.20.0.msi/from/http:/...

It was a fresh install or upgrade. I couldn't repeat with 64-bit installer performing a fresh install.

Fresh install.
I have also tried another time on a WinXP virtual maching.
During installation, all configuration use default value except "MySQL Root Password" use "',.pyf" (except "", beginning with "'", as the first 6 chars on Dvorak layout - just like qwerty on QWERTY...).
The Configuration Details shown below:

mysql-server-5.5-win32:6 - Looking for valid template
mysql-server-5.5-win32:13 - Found valid template.
mysql-server-5.5-win32:20 - Attempting to process template.
mysql-server-5.5-win32:26 - Processed template.
mysql-server-5.5-win32:33 - Attempting to configure service.
mysql-server-5.5-win32:40 - Configured service.
mysql-server-5.5-win32:46 - Attempting to start service.
mysql-server-5.5-win32:53 - Started service.
mysql-server-5.5-win32:60 - Adding firewall rule for MySQL55 on port 3306.
mysql-server-5.5-win32:66 - Adding firewall rule failed.
mysql-server-5.5-win32:73 - Attempting to update security settings.
mysql-server-5.5-win32:100 - Unable to update security settings. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.pyf') WHERE User='root'' at line 1
mysql-server-5.5-win32:86 - Attempting to verify command-line client shortcut.
mysql-server-5.5-win32:100 - Failed to verify command-line client shortcut.
mysql-server-5.5-win32:100 - Product configuration controller finished configuration.

Thank you for the bug report. Verified on 64-bit Windows XP also.

A fix for this bug has been submitted and should be available at the latest MSI.