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


1.3.1 MySQL Installer GUI

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

Full permissions are granted to the user executing MySQL Installer to all generated files, such as 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.

MySQL Installer requires you to accept the license agreement before it will install MySQL products.

Figure 1.1 MySQL Installer - License Agreement

MySQL Installer - License Agreement

Installing New Packages

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

  • Developer: Install all products needed to develop applications with MySQL. This is the default option.

  • Server only: Only install the MySQL server.

  • Client only: Only install the MySQL client products, such as MySQL Workbench. This does not include the MySQL server.

  • Full: Install all available MySQL products.

  • Custom: Manually select the MySQL products to install, and optionally configure custom MySQL data and installation paths.

    Note

    After the initial installation, you may use MySQL Installer to manually select MySQL products to install or remove. In other words, MySQL Installer becomes a MySQL product management system.

Figure 1.2 MySQL Installer - Choosing a Setup Type

MySQL Installer - Choosing a Setup Type

MySQL Installer checks your system for the external requirements (pre-requisites) required to install the selected MySQL products. MySQL Installer can download and install some prerequisites, but others require manual intervention. Download and install all prerequisites that have Status set to "Manual". Click Check to recheck if a manual prerequisite was installed. After manually installing those requirements, click Execute to download and install the other prerequisites. Once finished, click Next to continue.

Figure 1.3 MySQL Installer - Check Requirements

MySQL Installer - Check Requirements

The next window lists the MySQL products that are scheduled for installation:

Figure 1.4 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 1.5 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 (memory) that will be assigned to your MySQL server instance.

  • Developer: A machine that will host many other applications, and typically this is your personal workstation. This option configures MySQL to use the least amount of memory.

  • Server: Several other applications will be running on this machine, such as a web server. This option configures MySQL to use a medium amount of memory.

  • Dedicated: A machine that is dedicated to running the MySQL server. Because no other major applications will run on this server, such as a web server, this option configures MySQL to use the majority of available memory.

Connectivity

Connectivity options control how the connection to MySQL is made. Options include:

  • TCP/IP: You may enable TCP/IP Networking here as otherwise only localhost connections are allowed. Also define the Port Number and whether to open the firewall port for network access.

  • Named Pipe: Enable and define the pipe name, similar to using the --enable-named-pipe option.

  • Shared Memory: Enable and then define the memory name, similar to using the --shared-memory option.

Advanced Configuration

Check Show Advanced Options to set additional Logging Options. 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.

Figure 1.6 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 1.7 MySQL Installer - MySQL Server Configuration: User Accounts and Roles

MySQL Installer - MySQL Server Configuration: User Accounts and Roles

Figure 1.8 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 MySQL server Windows service is executed.

Figure 1.9 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. The Next button will be disabled until this user is configured with the required privileges.

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 1.10 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 1.11 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 1.12 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 1.13 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 1.14 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 General Availability (GA) status.

Select all of the MySQL products you want to install, then click Next to continue using the defaults, or highlight a selected product and click Advanced Options to optionally alter options such as the MySQL server data and installation paths. Click Execute to execute the installation process to install all of the selected products.


User Comments
  Posted by Victor Nieto T. on February 15, 2013
Es necesario que durante la instalación o después de ella, habilite en el firewall el puerto o el programas MySql, de lo contrario no le sera posible iniciar "local instance MySQL"
Sign Up Login You must be logged in to post a comment.