MySQL Administrator :: 6.3 Configure Service

Launch MySQL server automatically: If checked, the Windows service starts the MySQL server automatically on operating system startup.

Display Name: The display name of the Windows service (not the service name!) as it will appear in the Windows services manager when displaying the properties of that service.

Service Description: The description of the Windows service as it will appear in the Windows services manager.

Config Filename: You can enter the pathname of the server option file. MySQL will enter that information in the Windows registry, and the Windows service starting the MySQL server will use that file, rather than the default file (C:\windows installation directory\my.ini). Note that this is available for MySQL servers as of version 4.0.3 only. Details about the server option files can be found in the Creating an Option File section.

Section Name: Setting a value other than mysqld is most useful when running multiple servers; see Running Multiple Servers on Windows.

Support for InnoDB: If checked, the MySQL server is started with support for InnoDB tables. If unchecked, it doesn't start the InnoDB storage engine; this saves memory, but InnoDB tables cannot be used. If this checkbox is unchecked and greyed out, it means that your MySQL server isn't compiled with support for InnoDB tables. (This is, for example, true for some versions that run under a commercial license.) You can find more information on InnoDB tables in the MySQL Storage Engines and Table Types section.

Be careful when disabling this option! If any databases on the MySQL server contain InnoDB tables, disabling this option makes those tables inaccessible.

Support for BDB: If checked, the MySQL server is started with support for BDB tables. If unchecked, it doesn't start the BDB storage engine; this saves memory, but BDB tables cannot be used. If this checkbox is unchecked and greyed out, it means that your MySQL server isn't compiled with support for BDB tables. (This is, for example, true for non-max versions.) You can find more information on BDB tables in the MySQL Storage Engines and Table Types section.

Be careful when disabling this option! If any databases on the MySQL server contain BDB tables, disabling this option makes those tables inaccessible.

Named Pipes: On operating systems of the Windows NT family, including Windows NT, Windows 2000, and Windows XP, you may use named pipes to connect to a MySQL server running on the local machine, rather than connecting via TCP/IP. If this option is checked, named pipe connections are allowed. Note that named pipes are slower than TCP/IP in many Windows configurations. See the Selecting a MySQL Server type section for details.

Debug Information (slow): If checked, the MySQL server is started with an option that allows for easier debugging of problems. Using this option slows down the server significantly, so it is recommended only for debugging purposes. If the MySQL server has not been compiled with debugging support, this option is greyed out. See the mysqld Command-line Options section for details.

Path to Binary: Contains the pathname of the MySQL server binary file as it is listed in the Windows service manager (for example C:\mysql\bin\mysqld-max-nt). Note that the the Windows service manager does not display the .exe extension.