MySQL Installer for Windows User accounts may also be added and configured in MySQL Workbench. During the configuration process, click  Next  to proceed to the next step or  Back  to return to the previous step. Click  Execute  at the final step to apply the server configuration. The sections that follow describe the server configuration options that apply to MySQL server on Windows. The server version you installed will determine which steps and options you can configure. Configuring MySQL server may include some or all of the steps. •Checking  Show Advanced Options  enables 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. •Server Configuration Type • 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. •Connectivity • 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: • X Protocol Port  shown when configuring MySQL 8.0 server only. The default value is  33060 • Port  for classic MySQL protocol connections. The default value is  3306 . • Open Windows Firewall port for network access , which is selected by default for TCP/IP connections. • Named Pipe : Enable and define the pipe name, similar to setting the  named_pipe  system variable. The default name is  MySQL . • Shared Memory : Enable and define the memory name, similar to setting the  shared_memory system variable. The default name is  MySQL . •Advanced Configuration Type and Networking 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. Connectivity options control how the connection to MySQL is made. Options include: If a port number is in use already, you will see the information icon ( ) next to the default value and Next  is disabled until you provide a new port number. 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, 127