<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-configurator-workflow-server">
      </a>
      2.3.2.1 MySQL Server Configuration with MySQL Configurator
     </h4>
    </div>
   </div>
  </div>
  <p>
   MySQL Configurator performs the initial configuration, a reconfiguration,
      and also functions as part of the uninstallation process.
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    Full permissions are granted to the user executing MySQL Configurator to
        all generated files, such as
    <code class="filename">
     my.ini
    </code>
    . This
        does not apply to files and directories for specific products,
        such as the MySQL server data directory in
    <code class="literal">
     %ProgramData%
    </code>
    that is owned by
    <code class="literal">
     SYSTEM
    </code>
    .
   </p>
  </div>
  <p>
   MySQL Configurator performs the configuration of the MySQL server. For
      example:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      It creates the configuration file
          (
      <code class="filename">
       my.ini
      </code>
      ) that is used to configure the
          MySQL server. The values written to this file are influenced
          by choices you make during the installation process. Some
          definitions are host dependent.
     </p>
    </li>
    <li class="listitem">
     <p>
      By default, a Windows service for the MySQL server is added.
     </p>
    </li>
    <li class="listitem">
     <p>
      Provides default installation and data paths for MySQL server.
     </p>
    </li>
    <li class="listitem">
     <p>
      It can optionally create MySQL server user accounts with
          configurable permissions based on general roles, such as DB
          Administrator, DB Designer, and Backup Admin.
     </p>
    </li>
    <li class="listitem">
     <p>
      Checking
      <span class="guilabel">
       Show Advanced Options
      </span>
      enables
          additional
      <span class="guilabel">
       Logging Options
      </span>
      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.
     </p>
    </li>
   </ul>
  </div>
  <p>
   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.
  </p>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-existing-installations">
       </a>
       2.3.2.1.1 MySQL Server Installations
      </h5>
     </div>
    </div>
   </div>
   <p>
    MySQL Configurator adds an upgrade option if it finds an existing MySQL
        Server installation is discovered. It offers two options:
   </p>
   <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
    <div class="admon-title">
     Note
    </div>
    <p>
     This upgrade functionality was added in MySQL 8.3.0.
    </p>
   </div>
   <div class="simplesect">
    <div class="titlepage">
     <div>
      <div class="simple">
       <h6 class="title">
        <a name="server-existing-installations-replace">
        </a>
        In-Place Upgrade of an Existing MySQL Server Installation
       </h6>
      </div>
     </div>
    </div>
    <p>
     This replaces the existing MySQL server installation as part
          of the upgrade process which may also upgrade the data schema.
          Upon success, the existing MySQL server installation is
          removed from the system.
    </p>
    <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
     <div class="admon-title">
      Note
     </div>
     <p>
      The existing MySQL server instance must be running for the
            in-place upgrade option to function.
     </p>
    </div>
    <p>
     While MySQL Configurator may attempt (and succeed) to perform an
          in-place upgrade for other scenarios, the following table
          lists the scenarios officially supported by the configurator:
    </p>
    <div class="table">
     <a name="idm46045332346048">
     </a>
     <p class="title">
      <b>
       Table 2.5 Supported Upgrade Paths
      </b>
     </p>
     <div class="table-contents">
      <table summary="Upgrade paths officially supported by MySQL Configurator">
       <colgroup>
        <col style="width: 25%"/>
        <col style="width: 75%"/>
       </colgroup>
       <thead>
        <tr>
         <th scope="col">
          A supported upgrade scenario
         </th>
         <th scope="col">
          Description
         </th>
        </tr>
       </thead>
       <tbody>
        <tr>
         <td scope="row">
          8.0.35+ to 8.1
         </td>
         <td>
          From 8.0.35 or higher to the first MySQL 8 Innovation release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.0.35+ to 8.4
         </td>
         <td>
          From 8.0.35 or higher to the MySQL next LTS release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.X to 8.Y where Y = X + 1
         </td>
         <td>
          From an Innovation release to the next consecutive Innovation release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.3 to 8.4
         </td>
         <td>
          From the last MySQL 8 Innovation release to the next MySQL 8 LTS
                release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.4.X to 8.4.Y where Y &gt; X
         </td>
         <td>
          From within the same LTS release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.4.X to 9.0.0
         </td>
         <td>
          From an LTS release to the first consecutive Innovation release.
         </td>
        </tr>
        <tr>
         <td scope="row">
          8.4 to 9.7
         </td>
         <td>
          From an LTS release to the next consecutive LTS release.
         </td>
        </tr>
       </tbody>
      </table>
     </div>
    </div>
    <br class="table-break"/>
    <p>
     This dialogue prompts for the protocol (default: TCP/IP), port
          (default: 3306), and root password for the existing
          installation. Execute connect and then review and confirm the
          MySQL instance's information (such as version, paths, and
          configuration file) before proceeding with the upgrade.
    </p>
    <p>
     This upgrade may replace the file paths. For example, "MySQL
          Server 8.2\Data\" changes to "MySQL Server 8.3\Data\" when
          upgrading 8.2 to 8.3.
    </p>
    <p>
     This upgrade functionality also provides these additional
          options: "Backup Data" allows running
     <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
      <span class="command">
       <strong>
        mysqldump
       </strong>
      </span>
     </a>
     before performing the upgrade,
          and "Server File Permissions" to optionally customize file
          permissions.
    </p>
   </div>
   <div class="simplesect">
    <div class="titlepage">
     <div>
      <div class="simple">
       <h6 class="title">
        <a name="server-existing-installations-add">
        </a>
        Add a Separate MySQL Server Installation
       </h6>
      </div>
     </div>
    </div>
    <p>
     Configure a standard side-by-side installation with the new
          MySQL server installation. This means having multiple MySQL
          server installations installed and running on the system.
    </p>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-type-network">
       </a>
       2.3.2.1.2 Type and Networking
      </h5>
     </div>
    </div>
   </div>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       Server Configuration Type
      </p>
      <p>
       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.
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <span class="bold">
           <strong>
            Development
           </strong>
          </span>
          : 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.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="bold">
           <strong>
            Server
           </strong>
          </span>
          : 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.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="bold">
           <strong>
            Dedicated
           </strong>
          </span>
          : 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.
         </p>
        </li>
        <li class="listitem">
         <p>
         </p>
         <p>
          <span class="bold">
           <strong>
            Manual
           </strong>
          </span>
          : Prevents
                MySQL Configurator from attempting to optimize the server
                installation, and instead, sets the default values to
                the server variables included in the
          <code class="filename">
           my.ini
          </code>
          configuration file. With the
          <code class="literal">
           Manual
          </code>
          type selected, MySQL Configurator uses
                the default value of 16M for the
          <a class="link" href="server-system-variables.html#sysvar_tmp_table_size">
           <code class="literal">
            tmp_table_size
           </code>
          </a>
          variable
                assignment.
         </p>
        </li>
       </ul>
      </div>
     </li>
     <li class="listitem">
      <p>
       Connectivity
      </p>
      <p>
       Connectivity options control how the connection to MySQL is
            made. Options include:
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <span class="guilabel">
           TCP/IP
          </span>
          : 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:
         </p>
         <div class="itemizedlist">
          <ul class="itemizedlist" style="list-style-type: square; ">
           <li class="listitem">
            <p>
             <span class="guilabel">
              Port
             </span>
             for classic MySQL protocol
                    connections. The default value is
             <code class="literal">
              3306
             </code>
             .
            </p>
           </li>
           <li class="listitem">
            <p>
             <span class="guilabel">
              X Protocol Port
             </span>
             defaults to
             <code class="literal">
              33060
             </code>
            </p>
           </li>
           <li class="listitem">
            <p>
             <span class="guilabel">
              Open Windows Firewall port for network
                    access
             </span>
             , which is selected by default for
                    TCP/IP connections.
            </p>
           </li>
          </ul>
         </div>
         <p>
          If a port number is in use already, you will see the
                error icon (
          <span class="inlinemediaobject">
           <img align="middle" height="20" src="images/mi-info-symbol.png" width="22"/>
          </span>
          ) next to the default value and
          <span class="guibutton">
           Next
          </span>
          is disabled until you
                provide a new port number.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Named Pipe
          </span>
          : Enable and define the
                pipe name, similar to setting the
          <a class="link" href="server-system-variables.html#sysvar_named_pipe">
           <code class="literal">
            named_pipe
           </code>
          </a>
          system
                variable. The default name is
          <code class="literal">
           MySQL
          </code>
          .
         </p>
         <p>
          When you select
          <span class="guilabel">
           Named Pipe
          </span>
          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.
         </p>
         <p>
          You can set the level of access control based on the
                Windows user (or users) running the client as follows:
         </p>
         <div class="itemizedlist">
          <ul class="itemizedlist" style="list-style-type: square; ">
           <li class="listitem">
            <p>
             <b>
              Minimum access to all users (RECOMMENDED).
             </b>
             This level is enabled by default because it is the
                      most secure.
            </p>
           </li>
           <li class="listitem">
            <p>
             <b>
              Full access to members of a local group.
             </b>
             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.
            </p>
           </li>
           <li class="listitem">
            <p>
             <b>
              Full access to all users (NOT RECOMMENDED).
             </b>
             This option is less secure and should be set only
                      when other safeguards are implemented.
            </p>
           </li>
          </ul>
         </div>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Shared Memory
          </span>
          : Enable and define
                the memory name, similar to setting the
          <a class="link" href="server-system-variables.html#sysvar_shared_memory">
           <code class="literal">
            shared_memory
           </code>
          </a>
          system
                variable. The default name is
          <code class="literal">
           MySQL
          </code>
          .
         </p>
        </li>
       </ul>
      </div>
     </li>
     <li class="listitem">
      <p>
       Advanced Configuration
      </p>
      <p>
       Check
       <span class="guilabel">
        Show Advanced and Logging Options
       </span>
       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.
      </p>
     </li>
     <li class="listitem">
      <p>
       MySQL Enterprise Firewall (Enterprise Edition only)
      </p>
      <p>
       The
       <span class="guilabel">
        Enable MySQL Enterprise Firewall
       </span>
       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
       <a class="xref" href="firewall.html" title="8.4.7 MySQL Enterprise Firewall">
        Section 8.4.7, “MySQL Enterprise Firewall”
       </a>
       ).
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-accounts-roles">
       </a>
       2.3.2.1.3 Accounts and Roles
      </h5>
     </div>
    </div>
   </div>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       Root Account Password
      </p>
      <p>
       Assigning a root password is required and you will be asked
            for it when reconfiguring with MySQL Configurator in the future.
            Password strength is evaluated when you repeat the password
            in the box provided. For descriptive information regarding
            password requirements or status, move your mouse pointer
            over the information icon (
       <span class="inlinemediaobject">
        <img align="middle" height="20" src="images/mi-info-symbol.png" width="22"/>
       </span>
       ) when it appears.
      </p>
     </li>
     <li class="listitem">
      <p>
       MySQL User Accounts (Optional)
      </p>
      <p>
       Click
       <span class="guibutton">
        Add User
       </span>
       or
       <span class="guibutton">
        Edit
            User
       </span>
       to create or modify MySQL user accounts
            with predefined roles. Next, enter the required account
            credentials:
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <span class="guilabel">
           User Name:
          </span>
          MySQL user names can be
                up to 32 characters long.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Host:
          </span>
          Select
          <code class="literal">
           localhost
          </code>
          for local connections only
                or
          <code class="literal">
           &lt;All Hosts (%)&gt;
          </code>
          when remote
                connections to the server are required.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Role:
          </span>
          Each predefined role, such as
          <code class="literal">
           DB Admin
          </code>
          , is configured with its own
                set of privileges. For example, the
          <code class="literal">
           DB
                Admin
          </code>
          role has more privileges than the
          <code class="literal">
           DB Designer
          </code>
          role. The
          <span class="guilabel">
           Role
          </span>
          drop-down list contains a
                description of each role.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Password:
          </span>
          Password strength
                assessment is performed while you type the password.
                Passwords must be confirmed. MySQL permits a blank or
                empty password (considered to be insecure).
         </p>
        </li>
       </ul>
      </div>
      <p>
       <b>
        MySQL Configurator Commercial Release Only:
       </b>
       MySQL Enterprise Edition for Windows, a commercial product, also supports an
              authentication method that performs external
              authentication on Windows. Accounts authenticated by the
              Windows operating system can access the MySQL server
              without providing an additional password.
      </p>
      <p>
       To create a new MySQL account that uses Windows
            authentication, enter the user name and then select a value
            for
       <span class="guilabel">
        Host
       </span>
       and
       <span class="guilabel">
        Role
       </span>
       .
            Click
       <span class="guilabel">
        Windows
       </span>
       authentication to enable
            the
       <code class="literal">
        authentication_windows
       </code>
       plugin. In the
            Windows Security Tokens area, enter a token for each Windows
            user (or group) who can authenticate with the MySQL user
            name. MySQL accounts can include security tokens for both
            local Windows users and Windows users that belong to a
            domain. Multiple security tokens are separated by the
            semicolon character (
       <code class="literal">
        ;
       </code>
       ) and use the
            following format for local and domain accounts:
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          Local account
         </p>
         <p>
          Enter the simple Windows user name as the security token
                for each local user or group; for example,
          <strong class="userinput">
           <code>
            finley;jeffrey;admin
           </code>
          </strong>
          .
         </p>
        </li>
        <li class="listitem">
         <p>
          Domain account
         </p>
         <p>
          Use standard Windows syntax
                (
          <em class="replaceable">
           <code>
            domain
           </code>
          </em>
          <code class="literal">
           \
          </code>
          <em class="replaceable">
           <code>
            domainuser
           </code>
          </em>
          )
                or MySQL syntax
                (
          <em class="replaceable">
           <code>
            domain
           </code>
          </em>
          <code class="literal">
           \\
          </code>
          <em class="replaceable">
           <code>
            domainuser
           </code>
          </em>
          )
                to enter Windows domain users and groups.
         </p>
         <p>
          For domain accounts, you may need to use the credentials
                of an administrator within the domain if the account
                running MySQL Configurator lacks the permissions to query the
                Active Directory. If this is the case, select
          <span class="guilabel">
           Validate Active Directory users
                with
          </span>
          to activate the domain administrator
                credentials.
         </p>
        </li>
       </ul>
      </div>
      <p>
       Windows authentication permits you to test all of the
            security tokens each time you add or modify a token. Click
       <span class="guibutton">
        Test Security Tokens
       </span>
       to validate (or
            revalidate) each token. Invalid tokens generate a
            descriptive error message along with a red
       <code class="literal">
        X
       </code>
       icon and red token text. When all
            tokens resolve as valid (green text without an
       <code class="literal">
        X
       </code>
       icon), you can click
       <span class="guibutton">
        OK
       </span>
       to save the changes.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-windows-service">
       </a>
       2.3.2.1.4 Windows Service
      </h5>
     </div>
    </div>
   </div>
   <p>
    On the Windows platform, MySQL server can run as a named service
        managed by the operating system and be configured to start up
        automatically when Windows starts. Alternatively, you can
        configure MySQL server to run as an executable program that
        requires manual configuration.
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <span class="guilabel">
        Configure MySQL server as a Windows
            service
       </span>
       (Selected by default.)
      </p>
      <p>
       When the default configuration option is selected, you can
            also select the following:
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <span class="guilabel">
           Windows Service Name
          </span>
         </p>
         <p>
          Defaults to MySQL
          <em class="replaceable">
           <code>
            XY
           </code>
          </em>
          where XY
                is 81 for MySQL 8.1.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Start the MySQL Server at System
                Startup
          </span>
         </p>
         <p>
          When selected (default), the service startup type is set
                to Automatic; otherwise, the startup type is set to
                Manual.
         </p>
        </li>
        <li class="listitem">
         <p>
          <span class="guilabel">
           Run Windows Service as
          </span>
         </p>
         <p>
          When
          <span class="guilabel">
           Standard System Account
          </span>
          is
                selected (default), the service logs on as Network
                Service.
         </p>
         <p>
          The
          <span class="guilabel">
           Custom User
          </span>
          option must have
                privileges to log on to Microsoft Windows as a service.
                The
          <span class="guibutton">
           Next
          </span>
          button will be disabled
                until this user is configured with the required
                privileges.
         </p>
         <p>
          A custom user account is configured in Windows by
                searching for "local security policy" in the Start menu.
                In the Local Security Policy window, select
          <span class="guilabel">
           Local Policies
          </span>
          ,
          <span class="guilabel">
           User
                Rights Assignment
          </span>
          , and then
          <span class="guilabel">
           Log On
                As A Service
          </span>
          to open the property dialog.
                Click
          <span class="guibutton">
           Add User or Group
          </span>
          to add
                the custom user and then click
          <span class="guibutton">
           OK
          </span>
          in each dialog to save the changes.
         </p>
        </li>
       </ul>
      </div>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-file-permission-options">
       </a>
       2.3.2.1.5 Server File Permissions
      </h5>
     </div>
    </div>
   </div>
   <p>
    Optionally, permissions set on the folders and files located at
    <code class="filename">
     C:\ProgramData\MySQL\MySQL Server
     <em class="replaceable">
      <code>
       X.Y
      </code>
     </em>
     \Data
    </code>
    can be managed
        during the server configuration operation. You have the
        following options:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       MySQL Configurator can configure the folders and files with full
            control granted exclusively to the user running the Windows
            service, if applicable, and to the Administrators group.
      </p>
      <p>
       All other groups and users are denied access. This is the
            default option.
      </p>
     </li>
     <li class="listitem">
      <p>
       Have MySQL Configurator use a configuration option similar to the one
            just described, but also have MySQL Configurator show which users
            could have full control.
      </p>
      <p>
       You are then able to decide if a group or user should be
            given full control. If not, you can move the qualified
            members from this list to a second list that restricts all
            access.
      </p>
     </li>
     <li class="listitem">
      <p>
       Have MySQL Configurator skip making file-permission changes during
            the configuration operation.
      </p>
      <p>
       If you select this option, you are responsible for securing
            the
       <code class="filename">
        Data
       </code>
       folder and its related files
            manually after the server configuration finishes.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-logging-options">
       </a>
       2.3.2.1.6 Logging Options
      </h5>
     </div>
    </div>
   </div>
   <p>
    This step is available if the
    <span class="guilabel">
     Show Advanced
        Configuration
    </span>
    check box was selected during the
    <span class="guilabel">
     Type and Networking
    </span>
    step. To enable this
        step now, click
    <span class="guibutton">
     Back
    </span>
    to return to the
    <span class="guilabel">
     Type and Networking
    </span>
    step and select the
        check box.
   </p>
   <p>
    Advanced configuration options are related to the following
        MySQL log files:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <a class="link" href="error-log.html" title="7.4.2 The Error Log">
        Error Log
       </a>
      </p>
     </li>
     <li class="listitem">
      <p>
       <a class="link" href="query-log.html" title="7.4.3 The General Query Log">
        General Log
       </a>
      </p>
     </li>
     <li class="listitem">
      <p>
       <a class="link" href="slow-query-log.html" title="7.4.5 The Slow Query Log">
        Slow Query Log
       </a>
      </p>
     </li>
     <li class="listitem">
      <p>
       <a class="link" href="binary-log.html" title="7.4.4 The Binary Log">
        Binary Log
       </a>
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-advanced-options">
       </a>
       2.3.2.1.7 Advanced Options
      </h5>
     </div>
    </div>
   </div>
   <p>
    This step is available if the
    <span class="guilabel">
     Show Advanced
        Configuration
    </span>
    check box was selected during the
    <span class="guilabel">
     Type and Networking
    </span>
    step. To enable this
        step now, click
    <span class="guibutton">
     Back
    </span>
    to return to the
    <span class="guilabel">
     Type and Networking
    </span>
    step and select the
        check box.
   </p>
   <p>
    The advanced-configuration options include:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <span class="guilabel">
        Server ID
       </span>
      </p>
      <p>
       Set the unique identifier used in a replication topology. If
            binary logging is enabled, you must specify a server ID. The
            default ID value depends on the server version. For more
            information, see the description of the
       <a class="link" href="replication-options.html#sysvar_server_id">
        <code class="literal">
         server_id
        </code>
       </a>
       system variable.
      </p>
     </li>
     <li class="listitem">
      <p>
       <span class="guilabel">
        Table Names Case
       </span>
      </p>
      <p>
       These options only apply to the initial configuration of the
            MySQL server.
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          Lower Case
         </p>
         <p>
          Sets the
          <a class="link" href="server-system-variables.html#sysvar_lower_case_table_names">
           <code class="literal">
            lower_case_table_names
           </code>
          </a>
          option value to 1 (default), in which table names are
                stored in lowercase on disk and comparisons are not
                case-sensitive.
         </p>
        </li>
        <li class="listitem">
         <p>
          Preserve Given Case
         </p>
         <p>
          Sets the
          <a class="link" href="server-system-variables.html#sysvar_lower_case_table_names">
           <code class="literal">
            lower_case_table_names
           </code>
          </a>
          option value to 2, in which table names are stored as
                given but compared in lowercase.
         </p>
        </li>
       </ul>
      </div>
     </li>
    </ul>
   </div>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-sample-databases">
       </a>
       2.3.2.1.8 Sample Databases
      </h5>
     </div>
    </div>
   </div>
   <p>
    Optionally install sample databases that include test data to
        help develop applications with MySQL. The options include the
    <a class="ulink" href="/doc/sakila/en/" target="_top">
     sakila
    </a>
    and
    <a class="ulink" href="/doc/world-setup/en/" target="_top">
     world
    </a>
    databases.
   </p>
  </div>
  <div class="section">
   <div class="titlepage">
    <div>
     <div>
      <h5 class="title">
       <a name="server-apply-config">
       </a>
       2.3.2.1.9 Apply Configuration
      </h5>
     </div>
    </div>
   </div>
   <p>
    All configuration settings are applied to the MySQL server when
        you click
    <span class="guibutton">
     Execute
    </span>
    . Use the
    <span class="guilabel">
     Configuration Steps
    </span>
    tab to follow the
        progress of each action; the icon for each toggles from white to
        green (with a check mark) on success. Otherwise, the process
        stops and displays an error message if an individual action
        times out. Click the
    <span class="guilabel">
     Log
    </span>
    tab to view the
        log.
   </p>
  </div>
 </div>
 <br/>
</div>
