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 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.
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.exe supports the following command options:
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
-
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 isDeveloper
,Client
, orFull
. 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 serverClient
: Installs client programs and librariesFull
: Installs everythingCustom
: Installs user-selected products. This is the default option.
NoteNon-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
orx64
) 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 themodify
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
oruser
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.NoteThe
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
-
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
-
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
Downloads the latest MySQL product catalog to your system. On success, the catalog is applied the next time either
MySQLInstaller
or MySQLInstallerConsole.exe is executed.C:\> MySQLInstallerConsole update
NoteThe 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
-