Related Documentation Download this Excerpt
PDF (US Ltr) - 2.3Mb
PDF (A4) - 2.3Mb
EPUB - 1.9Mb
HTML Download (TGZ) - 1.9Mb
HTML Download (Zip) - 1.9Mb

MySQL and Windows  /  Installing MySQL on Microsoft Windows  /  Installing MySQL on Microsoft Windows Using MySQL Installer

1.3 Installing MySQL on Microsoft Windows Using MySQL Installer

MySQL Installer is an application that manages MySQL products on Microsoft Windows. It installs, updates, removes, and configures MySQL products, and remains on the system as its own application. MySQL Installer is only available for Microsoft Windows, and includes both GUI and command-line interfaces.

The supported MySQL products include:

Installer Package Types

  • Full: Bundles all of the MySQL products (including the MySQL server). The file size is over 300MB, and its name has the form mysql-installer-community-VERSION.N.msi where VERSION is the MySQL Server version number such as 5.7 and N is the package number, which begins at 0.

  • Web: Only contains MySQL Installer and configuration files, and it downloads the MySQL products you choose to install. The size of this file is about 2MB; the name of the file has the form mysql-installer-community-web-VERSION.N.msi where VERSION is the MySQL Server version number such as 5.7 and N is the package number, which begins at 0.

  • Updates: MySQL Installer can upgrade itself, so an additional download is not requires to update MySQL Installer.

Installer Editions

  • Community edition: Downloadable at It installs the community edition of all MySQL products.

  • Commercial edition: Downloadable at either My Oracle Support (MOS) or It installs the commercial version of all MySQL products, including Workbench SE/EE, MySQL Enterprise Backup, and MySQL Enterprise Firewall. It also integrates with your MOS account.


    Entering your MOS credentials is optional when installing bundled MySQL products, but your credentials are required when choosing non-bundled MySQL products that MySQL Installer must download.

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 same host.


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

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

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


    Some definitions are host dependent. For example, query_cache is enabled if the host has fewer than three cores.

  • It can optionally import example databases.

  • By default, a Windows service for the MySQL server is added.

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

  • Checking Show Advanced Options allows additional Logging Options to be set. This includes defining custom 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.

User Comments
  Posted by Yanfei Zhao on October 22, 2016
MySQL Documentation Comment Policy

On average, over ten comments a day are posted for the MySQL reference manual. Many of these comments will be deleted by Oracle employees and volunteers shortly after being posted. These comments are deleted because Oracle wants to keep the number of comments in the reference manual at a minimum.

Our goal is to make the reference manual clear and concise enough that extra comments are not necessary. Fewer comments makes for a neater appearance and help with the consistency of the manual.

There are of course occasions where a comment is helpful and necessary, and we appreciate those users who wish to share their wisdom. Here are some guidelines on how to ensure your comment is not later deleted:

The user comment system in the MySQL manual is not the place to ask questions. If you need help to solve a problem, please use one of our public mailing lists or our online forums.
The user comment system in the MySQL manual is not the place to report bugs. If you believe you have found a bug, please generate a repeatable test case for the problem and submit a bug report.
The user comment system in the MySQL manual is not the place to request features. You can do so using our bug-tracking system.
When sharing information through the comment system, make sure that your information is not already present in the manual. Not only should you check the page you will be commenting on, you should also search the manual to see if the information is present on another page.
When leaving a comment, try not to be specific to a particular programming language or situation. Comments sharing a snippet of PHP code used in a particular project will almost certainly be deleted. Try to ensure your comment applies to as wide a group as possible.
If you have found an error in the documentation or have feedback to make about the documentation, you are encouraged to either file a bug report or contact us online rather than use the user comment system.
Please do not place links to web sites in the user comment system unless the link is very relevant. Users who repeatedly link to unrelated sites may find themselves banned from leaving comments.
Please understand that if we delete your comment it's nothing personal, we are simply doing our best to find a balance and limit the number of comments present in our documentation. We do appreciate your attempts to help your fellow MySQL users.
  Posted by Yanfei Zhao on October 22, 2016
I have been checking the MySQL Documentation for ALTER TABLE and it does not seem to include a way to add or modify a comment to a column
Sign Up Login You must be logged in to post a comment.