MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
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 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.
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.
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
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
is executed.
C:\> MySQLInstallerConsole update
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