Bug #86683 MySQLInstallerConsole.exe -silent doesn't work on upgrade
Submitted: 13 Jun 2017 17:37 Modified: 17 Aug 2022 22:04
Reporter: Marcelo Altmann (OCA) Email Updates:
Status: Closed 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 2021 13:07] MySQL Verification Team
Bug #102526 marked as duplicate of this one.
[21 Jul 2022 18:02] Jose Ramirez
Posted by developer:
 
The "upgrade" action does no longer request for confirmations when using the "--silent" option. If using Installer commercial and no MOS credentials are provided, the upgrade will fail.
[17 Aug 2022 22:04] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.6.4 release, and here's the proposed changelog entry from the documentation team:

The mysqlinstallerconsole.exe command's original -silent option prompted
for user input. Starting with this version of MySQL Installer, the
command’s new --silent option eliminates all command interaction as
expected.

Thank you for the bug report.