Rechercher dans le manuel MySQL

2.3.3.5 MySQLInstallerConsole Reference

Inhoudsopgave

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 directory. Typically, that is in C:\Program Files (x86)\MySQL\MySQL Installer\, 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.

MySQLInstallerConsole.exe supports the following commands:

Note

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

  • configure [product1]:[setting]=[value]; [product2]:[setting]=[value]; [...]

    Configure 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 : Disable 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]; [...]

    Install 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 "SetupType" can be one of the following:

      Note

      Non-custom setup types can only be chosen if no other MySQL products are installed.

      • 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.

    • -showsettings : Displays the available options for the selected product, by passing in the product name after -showsettings.

    • -silent : Disable confirmation prompts.

    • [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, where "config" is the default type if one is not defined.

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

      Only one "config" type block can be defined per product. A "user" block should be defined for each user that should be created during the product's installation.

      Note

      Adding users is not supported when a product is being reconfigured.

    • [feature]: The feature block is a semicolon separated list of features, or an asterisk character (*) to select all features. 

    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.

    • -silent : Disable confirmation prompts. 

    C:\> MySQLInstallerConsole modify server
C:\> MySQLInstallerConsole modify server:+documentation
C:\> MySQLInstallerConsole modify server:-debug

  • remove [product1] [product2] [...]

    Removes one ore more products from your system.

    • * : 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 download catalog will be 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:6.3.5
C:\> MySQLInstallerConsole upgrade workbench:!
C:\> MySQLInstallerConsole upgrade workbench:6.3.5 excel:1.3.2

Zoek in de MySQL-handleiding

Nederlandse vertaling

U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.

Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.

Bij voorbaat dank.

Document heeft de 26/06/2006 gemaakt, de laatste keer de 26/10/2018 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/mysql-rf-MySQLInstallerConsole.html

De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.

Referenties

  1. Bekijk - html-document Taal van het document:en Manuel MySQL : https://dev.mysql.com/

Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.

Inhoudsopgave Haut