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.
Files that are generated by MySQL Installer grant full permissions to the
user that executes MySQL Installer, including
This does not apply to files and directories for specific
products such as the MySQL Server data directory in
%ProgramData% that is owned by
The initial execution of MySQL Installer requires you to accept the license agreement before installing MySQL 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, which does not include the MySQL server.
Full: Install all MySQL products.
Custom: Manually select the MySQL products to install.
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.
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:
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 the MySQL server begins with defining several Type and Networking options.
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.
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 are running on the server, such as web servers, this option configures MySQL to use all available memory.
Connectivity options control how you will connect to MySQL. 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
Shared Memory: Enable and then define the
memory name, similar to using the
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.
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.
If the MySQL Server is already installed, then you must also
Current Root Password.
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.
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
User Rights Assignment, then
As A Service. Choose
Add User or
Group here to add the custom user, and then
OK, OK to save.
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:
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.
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
Click Add to add new products. This loads the Select Products and Features page:
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:
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.
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.