2.3.3 Installing MySQL on Microsoft Windows Using MySQL Installer

2.3.3.1 MySQL Installer GUI
2.3.3.2 MySQL Installer Console

MySQL Installer simplifies the installation and updating process for your MySQL products on Microsoft Windows. From this central application, you can view, remove, update, and reconfigure the existing MySQL products on your system. MySQL Installer can also install plugins, documentation, tutorials, and example databases. The MySQL Installer is only available for Microsoft Windows, and includes both GUI and command-line interfaces.

The supported products include:

Installer package types

Installer editions

For notes detailing the changes in each release of MySQL Installer, see MySQL Installer Release Notes.

MySQL Installer is compatible with pre-existing installations, and adds them to its list of installed components. While the standard MySQL Installer is bundled with a specific version of MySQL Server, a single MySQL Installer instance can install and manage multiple MySQL Server versions. For example, a single MySQL Installer instance can install (and update) versions 5.5, 5.6, and 5.7 on the host.

Note

A single host can not have both community and commercial editions of MySQL Server installed. For example, if you want both MySQL Server 5.5 and 5.6 installed on a single host, then both must be the same edition.

MySQL Installer handles the initial configuration and set up of the applications. For example:

  1. It creates initial MySQL Server connections in MySQL Workbench.

  2. It creates the configuration file (my.ini) that is used to configure the MySQL Server. The values written to this file are influenced by choices you make during the installation process.

  3. It can optionally import example databases.

  4. It can optionally create MySQL Server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. It optionally creates a Windows user named MysqlSys with limited privileges, which would then run the MySQL Server.

    User accounts may also be added and configured in MySQL Workbench.

  5. If the "Advanced Configuration" option is checked, then the Logging Options are also configured. This includes defining file paths for the error log, general log, slow query log (including the configuration of seconds it requires to execute a query), and the binary log.

MySQL Installer can optionally check for updated components and download them for you.