2.3.3.5 MySQLInstallerConsole Reference

MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. It is installed when MySQL Installer is initially executed and then available within the MySQL Installer for Windows directory. By default, that is in C:\Program Files (x86)\MySQL\MySQL Installer for Windows, and the console must be executed with administrative privileges.

To use, invoke the command prompt with administrative privileges by choosing Start, Accessories, then right-click on Command Prompt and choose Run as administrator. And from the command line, optionally change the directory to where MySQLInstallerConsole.exe is located:

C:\> cd Program Files (x86)\MySQL\MySQL Installer for Windows
C:\Program Files (x86)\MySQL\MySQL Installer for Windows> MySQLInstallerConsole.exe help
=================== 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 11/1/2016 4:10:38 PM
=================== End Initialization ===================

The following commands are available:

Configure - Configures one or more of your installed programs.
Help      - Provides list of available commands.
Install   - Install and configure one or more available MySQL programs.
List      - Provides an interactive way to list all products available.
Modify    - Modifies the features of installed products.
Remove    - Removes one or more products from your system.
Status    - Shows the status of all installed products.
Update    - Update the current product catalog.
Upgrade   - Upgrades one or more of your installed programs.

MySQL Product Names

Many of the MySQLInstallerConsole commands accept one or more keywords that represent a MySQL product (or products) in the catalog. The current set of valid keywords for use with commands is shown in the following table.

Table 2.6 MySQL Product Keywords for MySQLInstallerConsole

Keyword	MySQL Product
`server`	MySQL Server
`workbench`	MySQL Workbench
`shell`	MySQL Shell
`visual`	MySQL for Visual Studio
`router`	MySQL Router
`backup`	MySQL Enterprise Backup
`net`	MySQL Connector/NET
`odbc`	MySQL Connector/ODBC
`c++`	MySQL Connector/C++
`python`	MySQL Connector/Python
`j`	MySQL Connector/J
`documentation`	MySQL Server Documentation
`samples`	MySQL Samples (sakila and world databases)

`MySQLInstallerConsole` Command Options

MySQLInstallerConsole.exe supports the following command options:

Note

Configuration block values that contain a colon character (:) must be wrapped in quotation marks. For example, installdir="C:\MySQL\MySQL Server 8.0".

configure [product1]:[setting]=[value]; [product2]:[setting]=[value]; [...]
Configures one or more MySQL products on your system. Multiple setting=value pairs can be configured for each product.
Switches include:
-showsettings
Displays the available options for the selected product, by passing in the product name after -showsettings.
-silent
Disables confirmation prompts.
```
C:\> MySQLInstallerConsole configure -showsettings server
C:\> MySQLInstallerConsole configure server:port=3307
```
help [command]
Displays a help message with usage examples and then exits. Pass in an additional command to receive help specific to that command.
```
C:\> MySQLInstallerConsole help
C:\> MySQLInstallerConsole help install
```
install [product]:[features]:[config block]:[config block]:[config block]; [...]
Installs one or more MySQL products on your system. If pre-release products are available, both GA and pre-release products are installed when the value of the -type switch is Developer, Client, or Full. Use the -only_ga_products switch to restrict the product set to GA products only when using these setup types.
Switches and syntax options include:
-only_ga_products
Restricts the product set to include GA products only.
-type=[SetupType]
Installs a predefined set of software. The setup type can be one of the following:
Developer: Installs a complete development environment.
Server: Installs a single MySQL server
Client: Installs client programs and libraries
Full: Installs everything
Custom: Installs user-selected products. This is the default option.
Note
Non-custom setup types are valid only when no other MySQL products are installed.
-showsettings
Displays the available options for the selected product, by passing in the product name after -showsettings.
-silent
Disable confirmation prompts.
[product]
Each product can be specified by a product keyword with or without a semicolon-separated version qualifier. Passing in a product keyword alone selects the latest version of the product. If multiple architectures are available for that version of the product, the command returns the first one in the manifest list for interactive confirmation. Alternatively, you can pass in the exact version and architecture (x86 or x64) after the product keyword using the -silent switch.
[features]
All features associated with a MySQL product are installed by default. The feature block is a semicolon-separated list of features or an asterisk character (*) that selects all features. To remove a feature, use the modify command.
[config block]
One or more configuration blocks can be specified. Each configuration block is a semicolon-separated list of key-value pairs. A block can include either a config or user type key; config is the default type if one is not defined.
Configuration block values that contain a colon character (:) must be wrapped in quotation marks. For example, installdir="C:\MySQL\MySQL Server 8.0". Only one configuration type block can be defined for each product. A user block should be defined for each user to be created during the product installation.
Note
The user type key is not supported when a product is being reconfigured.
```
C:\> MySQLInstallerConsole install server;5.6.25:*:port=3307;serverid=2:type=user;username=foo;password=bar;role=DBManager
C:\> MySQLInstallerConsole install server;5.6.25;x64 -silent
```
An example that passes in additional configuration blocks, separated by ^ to fit:
```
C:\> MySQLInstallerConsole install server;5.6.25;x64:*:type=config;openfirewall=true; ^
          generallog=true;binlog=true;serverid=3306;enable_tcpip=true;port=3306;rootpasswd=pass; ^
          installdir="C:\MySQL\MySQL Server 5.6":type=user;datadir="C:\MySQL\data";username=foo;password=bar;role=DBManager
```
list
Lists an interactive console where all of the available MySQL products can be searched. Execute MySQLInstallerConsole list to launch the console and enter in a substring to search.
```
C:\> MySQLInstallerConsole list
```
modify [product1:-removelist|+addlist] [product2:-removelist|+addlist] [...]
Modifies or displays features of a previously installed MySQL product. To display the features of a product, append the product keyword to the command, for example:
```
C:\> MySQLInstallerConsole modify server
```
The syntax option for this command:
-silent
Disable confirmation prompts.
```
C:\> MySQLInstallerConsole modify server:+documentation
C:\> MySQLInstallerConsole modify server:-debug
```
remove [product1] [product2] [...]
Removes one ore more products from your system. Switches and syntax options include:
*
Pass in * to remove all of the MySQL products.
-continue
Continue the operation even if an error occurs.
-silent
Disable confirmation prompts.
```
C:\> MySQLInstallerConsole remove *
C:\> MySQLInstallerConsole remove server
```
status
Provides a quick overview of the MySQL products that are installed on the system. Information includes product name and version, architecture, date installed, and install location.
```
C:\> MySQLInstallerConsole status
```
update
Downloads the latest MySQL product catalog to your system. On success, the catalog is applied the next time either MySQLInstaller or MySQLInstallerConsole is executed.
```
C:\> MySQLInstallerConsole update
```
Note
The Automatic Catalog Update GUI option executes this command from the Windows Task Scheduler.
upgrade [product1:version] [product2:version] [...]
Upgrades one or more products on your system. Syntax options include:
*
Pass in * to upgrade all products to the latest version, or pass in specific products.
!
Pass in ! as a version number to upgrade the MySQL product to its latest version.
-silent
Disable confirmation prompts.
```
C:\> MySQLInstallerConsole upgrade *
C:\> MySQLInstallerConsole upgrade workbench:8.0.21
C:\> MySQLInstallerConsole upgrade workbench:!
C:\> MySQLInstallerConsole upgrade workbench:8.0.21 visual:1.2.9
```

2.3.3.5 MySQLInstallerConsole Reference

MySQL Product Names

MySQLInstallerConsole Command Options

`MySQLInstallerConsole` Command Options