Bug #86683 MySQLInstallerConsole.exe -silent doesn't work on upgrade
Submitted: 13 Jun 2017 17:37 Modified: 14 Jun 2017 12:58
Reporter: Marcelo Altmann (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[13 Jun 2017 17:37] Marcelo Altmann
Description:
MySQLInstallerConsole.exe doesn't honor the -silent switch when running upgrade command.
Switch works as expected for install but doesn't for upgrade:

+++ INSTALL +++

C:\Program Files\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe install server;5.7.13:*:port=3306;serverid=2 -silent
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 6/13/2017 9:25:55 AM
=================== End Initialization ===================

Downloading MySQL Server 5.7.13...................Done!
[Install]  MySQL Server 5.7.13 X86...................done!
Product installations done.

Starting product configurations ...

Configuring MySQL Server 5.7.13
Stopping Server [if necessary] - Done!
Writing configuration file - Done!
Updating firewall - Done!
Adjusting Windows service [if necessary] - Done!
Updating server - Done!
Initializing Database [if necessary] - Done!
Starting Server - Done!
Applying security settings - Error!
Configuration of MySQL Server 5.7.13 has completed unsuccessfully!  (Check log for more details)
Finished configuring all selected products.

C:\Program Files\MySQL\MySQL Installer for Windows>

++++++++

No confirmation asked, and server 5.7.13 installed successfully.

+++ UPGRADE +++
C:\Program Files\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe upgrade server:5.7.18 -silent
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 6/13/2017 9:25:55 AM
=================== End Initialization ===================

The following upgrades will be performed:
    MySQL Server  5.7.13 -> 5.7.18
Press [Y] to continue, any other character to abort.

+++++++

MySQLInstallerConsole.exe requires you to press Y to continue the installation

How to repeat:
MySQLInstallerConsole.exe upgrade server:5.7.18 -silent

or

MySQLInstallerConsole.exe upgrade * -silent

Suggested fix:
Make the tool honor -silent switch and not ask for confirmation
[14 Jun 2017 12:58] Chiranjeevi Battula
Hello Marcelo Altmann,

Thank you for the bug report.

Thanks,
Chiranjeevi.
[14 Jun 2017 13:38] Chiranjeevi Battula
C:\Program Files (x86)\MySQL\MySQL Installer for Windows> MySQLInstallerConsole install server;5.7.13;x64 -silent
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 6/6/2017 10:39:46 AM
=================== End Initialization ===================

[Install]  MySQL Server 5.7.13 X64...................done!
Product installations done.

C:\Program Files (x86)\MySQL\MySQL Installer for Windows>MySQLInstallerConsole.exe upgrade server:5.7.18 -silent
=================== Start Initialization ===================
MySQL Installer is running in Community mode

Attempting to update manifest.
Initializing product requirements
Loading product catalog
Checking for product catalog snippets
Checking for product packages in the bundle
Categorizing product catalog
Finding all installed packages.
Your product catalog was last updated at 6/6/2017 10:39:46 AM
=================== End Initialization ===================

Upgrade MySQL Server 5.7.13-X64? [Y/N]Y
The following upgrades will be performed:
    MySQL Server  5.7.13 -> 5.7.18
Press [Y] to continue, any other character to abort.
[21 Apr 2020 13:36] neal smith
This is still a problem, upgrading from 8.0.17 to 8.0.19
[8 Feb 13:07] MySQL Verification Team
Bug #102526 marked as duplicate of this one.