Bug #77840 root password set up with semicolon character in between fails the configuration
Submitted: 27 Jul 2015 9:16 Modified: 23 Feb 2023 17:06
Reporter: Rick Novak Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:1.4.8.0 OS:Windows (Vista Business)
Assigned to: CPU Architecture:Any
Tags: password, root, semicolon, Starting Server

[27 Jul 2015 9:16] Rick Novak
Description:
Installing the MySQL 5.6.26 on MS Vista Business (using the Installer 1.4.8.0) I have put accidencially the semicolon character in between the root's password - it was something like blablabla;blebleble.
During the configuration phase the Installer failed and it was not clear, how to go over this problem. It has stopped at "Starting Server" point.
The information available in details’ window was as follows (see the lines 2 and 3 from the end):

Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Initializing Database [if necessary]
Initialize is only compatible for 5.7.7 or above, no need for Initialize the Database
Ended configuration step: Initializing Database [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service
Keyword not supported.
Nazwa parametru: blebleble;protocol
Ended configuration step: Starting Server

How to repeat:
The problem is actually solved, the MySQL server runs on my machine and doesn't need any special care.

Suggested fix:
Not to use the root's password with semicolon in between.

Installer should warn about it.
[27 Jul 2015 9:17] Rick Novak
errata
[27 Jul 2015 10:16] Chiranjeevi Battula
Hello Rick Novak,

Thank you for the bug report.
Verified this behavior on MySQL for Windows installer with 1.4.8.0 version

Thanks,
Chiranjeevi.
[27 Jul 2015 10:17] Chiranjeevi Battula
Beginning configuration step: Stopping Server [if necessary]
Ended configuration step: Stopping Server [if necessary]

Beginning configuration step: Writing configuration file
Ended configuration step: Writing configuration file

Beginning configuration step: Updating firewall
Adding firewall rule for MySQL56 on port 3306.
Successfully added firewall rule.
Ended configuration step: Updating firewall

Beginning configuration step: Adjusting Windows service [if necessary]
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service [if necessary]

Beginning configuration step: Initializing Database [if necessary]
Initialize is only compatible for 5.7.7 or above, no need for Initialize the Database
Ended configuration step: Initializing Database [if necessary]

Beginning configuration step: Starting Server
Starting MySQL as a service
Keyword not supported.
Parameter name: blebleble;protocol
Ended configuration step: Starting Server
[27 Jul 2015 10:18] Chiranjeevi Battula
screenshot

Attachment: 77840.PNG (image/png, text), 50.61 KiB.

[30 Jan 2017 7:31] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=84699  marked as duplicate of this one.
[13 Jun 2017 6:49] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=86661 marked as duplicate of this one.
[2 Oct 2018 14:08] Peter Brawley
Bug is still there, see https://forums.mysql.com/read.php?10,669269,669344, software should disallow pswd chars like ';'. Failing that, docs need to warn against their use in pswds.
[23 Feb 2023 17:06] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.6.6 release, and here's the proposed changelog entry from the documentation team:

Semicolons are now supported as part of a root password. All characters
that MySQL Server supports by default are also supported by MySQL
Installer.

Thank you for the bug report.