2.3.3.1 MySQL Installer GUI

2.3.3.1.1 MySQL Product Catalog
2.3.3.1.2 Remove MySQL Products
2.3.3.1.3 Alter MySQL Products

Installing MySQL Installer adds a link to the Start menu under the MySQL group. Click Start, All Programs MySQL, MySQL Installer to reload the MySQL Installer GUI.

Note

Files that are generated by MySQL Installer grant full permissions to the user that executes MySQL Installer, including my.ini. This does not apply to files and directories for specific products such as the MySQL Server data directory in %ProgramData% that is owned by SYSTEM.

The initial execution of MySQL Installer requires you to accept the license agreement before installing MySQL products.

Figure 2.7 MySQL Installer - License Agreement

MySQL Installer - License Agreement

Installing New Packages

Choose the appropriate Setup Type for your system. The selected type determines which MySQL products are installed on your system, or select Custom to manually choose individual products.

Figure 2.8 MySQL Installer - Choosing a Setup Type

MySQL Installer - Choosing a Setup Type

After you select a setup type, the MySQL Installer will check your system for the necessary external requirements for each of the selected MySQL products. MySQL Installer will either download and install the missing components onto your system, or point you to the download location and set Status to "Manual".

The next window lists the MySQL products that are scheduled to be installed:

Figure 2.9 MySQL Installer - Installation Progress

MySQL Installer - Installation Progress

As components are installed, their Status changes from a progress percentage to "Complete".

After all components are installed, the next step configures some of the recently installed MySQL products. The Configuration Overview window displays the progress and then loads a configuration window, if required. Our example configures MySQL Server 5.6.x.

Configuring MySQL Server

Configuring the MySQL server begins with defining several Type and Networking options.

Figure 2.10 MySQL Installer - Configuration Overview

MySQL Installer - Configuration Overview

Server Configuration Type

Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources that will be assigned to your MySQL server instance.

Connectivity

Connectivity options control how you will connect to MySQL. Options include:

Advanced Configuration

Checking the "Advanced Configuration" option provides additional Logging Options to configure. 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.

Figure 2.11 MySQL Installer - MySQL Server Configuration: Type and Networking

MySQL Installer- MySQL Server Configuration: Type and Networking

Accounts and Roles

Next, define your MySQL account information. Assigning a root password is required.

Optionally, you can add additional MySQL user accounts with predefined user roles. Each predefined role, such as "DB Admin", are configured with their own set of privileges. For example, the "DB Admin" role has more privileges than the "DB Designer" role. Click the Role dropdown for a list of role descriptions.

Note

If the MySQL Server is already installed, then you must also enter the Current Root Password.

Figure 2.12 MySQL Installer - MySQL Server Configuration: User Accounts and Roles

MySQL Installer - MySQL Server Configuration: User Accounts and Roles

Figure 2.13 MySQL Installer - MySQL Server Configuration: User Accounts and Roles: Adding a User

MySQL Installer - MySQL Server Configuration: User Accounts and Roles: Adding a User

Windows Service

Next, configure the Windows Service details. This includes the service name, whether the MySQL Server should be loaded at startup, and how the Windows Service for MySQL Server is executed.

Figure 2.14 MySQL Installer - MySQL Server Configuration: Windows Service

MySQL Installer - MySQL Server Configuration: Windows Service

Note

When configuring Run Windows Services as ... using a Custom User, the custom user must have privileges to log on to Microsoft Windows as a service. And the Next button will be disabled until this user is configured with these user rights.

On Microsoft Windows 7, this is configured by loading the Start Menu, Control Panel, Administrative Tools, Local Security Policy, Local Policies, User Rights Assignment, then Log On As A Service. Choose Add User or Group here to add the custom user, and then OK, OK to save.

Advanced Options

The next configuration step is available if the Advanced Configuration option was checked. This section includes options that are related to the MySQL log files:

Figure 2.15 MySQL Installer - MySQL Server Configuration: Logging Options

MySQL Installer - MySQL Server Configuration: Logging Options

Click Next to continue on to the final page before all of the requested changes are applied. This Apply Server Configuration page details the configuration steps that will be performed.

Figure 2.16 MySQL Installer - MySQL Server Configuration: Apply Server Configuration

MySQL Installer - MySQL Server Configuration: Apply Server Configuration

Click Execute to execute the configuration steps. The icon for each step toggles from white to green on success, or the process stops on failure. Click the Log tab to view the log.

After the MySQL Installer configuration process is finished, MySQL Installer reloads the opening page where you can execute other installation and configuration related actions.

MySQL Installer is added to the Microsoft Windows Start menu under the MySQL group. Opening MySQL Installer loads its dashboard where installed MySQL products are listed, and other MySQL Installer actions are available:

Figure 2.17 MySQL Installer - Main Dashboard

MySQL Installer - Main Dashboard

Adding MySQL Products

Click Add to add new products. This loads the Select Products and Features page:

Figure 2.18 MySQL Installer - Select Products and Features

MySQL Installer - Select Products and Features

From here, choose the MySQL products you want to install from the left Available Products pane, and then click the green right arrow to queue products for installation.

Optionally, click Edit to open the product and features search filter:

Figure 2.19 MySQL Installer - Select Products and Features Filter

MySQL Installer - Select Products and Features Filter

For example, you might choose to include Pre-Release products in your selections, such as a Beta product that has not yet reached GA status.

Note

The ability to install Pre-Release versions of MySQL products was added in MySQL Installer 1.4.0.

Select all of the MySQL products you want to install, then click Next to continue, and then Execute to execute the installation process to install all of the selected products.

2.3.3.1.1 MySQL Product Catalog

MySQL Installer stores a MySQL product catalog. The catalog can be updated either manually or automatically, and the catalog change history is also available.

Note

The MySQL product catalog was added in MySQL Installer 1.4.0.

Manual updates

You can update the MySQL product catalog at any time by clicking Catalog on the Installer dashboard.

Figure 2.20 MySQL Installer - Open the MySQL Product Catalog

MySQL Installer - Open the MySQL Product Catalog

From there, click Execute to update the product catalog.

Automatic updates

You can configure MySQL Installer to automatically update the MySQL product catalog once per day. To enable this feature and set the update time, click the wrench icon on the Installer dashboard.

The next window configures the Automatic Catalog Update. Enable or disable this feature, and also set the hour.

Figure 2.21 MySQL Installer - Configure the Catalog Scheduler

MySQL Installer - Configure the Catalog Scheduler

This option uses the Windows Task Scheduler to schedule a task named "ManifestUpdate".

Change History

MySQL Installer tracks the change history for all of the MySQL products. Click Catalog from the dashboard, optionally update the catalog (or, toggle the Do not update at this time checkbox), click Next/Execute, and then view the change history.

Figure 2.22 MySQL Installer - Catalog Change History

MySQL Installer - Catalog Change History

2.3.3.1.2 Remove MySQL Products

MySQL Installer can also remove MySQL products from your system. To remove a MySQL product, click Remove from the Installer dashboard. This opens a window with a list of installed MySQL products. Select the MySQL products you want to remove (uninstall), and then click Execute to begin the removal process.

Note

To select all MySQL products, click the [ ] checkbox to the left of the Product label.

Figure 2.23 MySQL Installer - Removing Products: Select

MySQL Installer - Removing Products: Select

Figure 2.24 MySQL Installer - Removing Products: Executed

MySQL Installer - Removing Products: Executed

2.3.3.1.3 Alter MySQL Products

MySQL Installer offers several options to alter your MySQL product installations.

Upgrade

MySQL products with an available upgrade are highlighted on the main dashboard. Products with available upgrades will have an upgrade icon next to their version number.

Figure 2.25 MySQL Installer - Upgrade a MySQL Product

MySQL Installer - Upgrade a MySQL Product

Note

Available upgrades are determined by having a current catalog. For information about keeping your MySQL product catalog current, see Section 2.3.3.1.1, “MySQL Product Catalog”.

Click Upgrade to view a list upgradable products. Our example indicates that MySQL server 5.6.19 can be upgraded to version 5.6.20.

Figure 2.26 MySQL Installer - Select Products To Upgrade

MySQL Installer - Select Products To Upgrade

Select (check) the products to upgrade, and optionally click the changes link to view the product's release notes in your browser. Click Next to begin the upgrade process.

Figure 2.27 MySQL Installer - Apply Updates

MySQL Installer - Apply Updates

A MySQL server upgrade will also check and upgrade the server's database. Although optional, this step is recommended.

Figure 2.28 MySQL Installer - Check and Upgrade Database

MySQL Installer - Check and Upgrade Database

Upon completion, your upgraded products will be upgraded and available to use. A MySQL server upgrade also restarts the MySQL server.

Reconfigure

Some MySQL products, such as the MySQL server, include a Reconfigure option. It opens the same configuration options that were set when the MySQL product was installed, and is pre-populated with the current values.

To execute, click the Reconfigure link under the Quick Action column on the main dashboard for the MySQL product that you want to reconfigure.

Figure 2.29 MySQL Installer - Reconfigure a MySQL Product

MySQL Installer - Reconfigure a MySQL Product

In the case of the MySQL server, this opens the familiar configuration wizard.

Figure 2.30 MySQL Installer - Reconfiguration Wizard

MySQL Installer - Reconfiguration Wizard

Modify

Many MySQL products contain feature components that can be added or removed. For example, Debug binaries and Client Programs are subcomponents of the MySQL server.

The modify the features of a product, click Modify on the main dashboard.

Figure 2.31 MySQL Installer - Modify Product Features

MySQL Installer - Modify Product Features

Click Execute to execute the modification request.