Server Configuration Type
Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources (memory) to assign to your MySQL server instance.
Development: A computer that hosts many other applications, and typically this is your personal workstation. This setting configures MySQL to use the least amount of memory.
Server: Several other applications are expected to run on this computer, such as a web server. The Server setting configures MySQL to use a medium amount of memory.
Dedicated: A computer that is dedicated to running the MySQL server. Because no other major applications run on this server, this setting configures MySQL to use the majority of available memory.
Manual: Prevents MySQL Configurator from attempting to optimize the server installation, and instead, sets the default values to the server variables included in the
my.iniconfiguration file. With the
Manualtype selected, MySQL Configurator uses the default value of 16M for the
Connectivity options control how the connection to MySQL is made. Options include:
TCP/IP: This option is selected by default. You may disable TCP/IP Networking to permit local host connections only. With the TCP/IP connection option selected, you can modify the following items:
Port for classic MySQL protocol connections. The default value is
X Protocol Port defaults to
Open Windows Firewall port for network access, which is selected by default for TCP/IP connections.
If a port number is in use already, you will see the error icon () next to the default value andis disabled until you provide a new port number.
Named Pipe: Enable and define the pipe name, similar to setting the
named_pipesystem variable. The default name is
When you select Named Pipe connectivity, and then proceed to the next step, you are prompted to set the level of access control granted to client software on named-pipe connections. Some clients require only minimum access control for communication, while other clients require full access to the named pipe.
You can set the level of access control based on the Windows user (or users) running the client as follows:
Minimum access to all users (RECOMMENDED). This level is enabled by default because it is the most secure.
Full access to members of a local group. If the minimum-access option is too restrictive for the client software, use this option to reduce the number of users who have full access on the named pipe. The group must be established on Windows before you can select it from the list. Membership in this group should be limited and managed. Windows requires a newly added member to first log out and then log in again to join a local group.
Full access to all users (NOT RECOMMENDED). This option is less secure and should be set only when other safeguards are implemented.
Shared Memory: Enable and define the memory name, similar to setting the
shared_memorysystem variable. The default name is
Check Show Advanced and Logging Options to set custom logging and advanced options in later steps. The Logging Options step enables you to define 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. The Advanced Options step enables you to set the unique server ID required when binary logging is enabled in a replication topology.
MySQL Enterprise Firewall (Enterprise Edition only)
The Enable MySQL Enterprise Firewall check box is deselected by default. Select this option to enable a security list that offers protection against certain types of attacks. Additional post-installation configuration is required (see MySQL Enterprise Firewall).