Table of Contents
This section shows how to start and stop the MySQL server you have connected to. Currently, this is only possible if the server is running on the same machine that hosts MySQL Administrator and if that service has been configured. (Future releases will be capable of starting and stopping MySQL servers on remote machines.) If the server runs as a stand-alone application, the Service Control section will not be enabled.
The Configure Service tab is available only for MySQL servers that run under Windows.
The Start/Stop Service
tab displays the status
of the MySQL service. This service starts and stops the MySQL
server. Under Service Status
, a text message
indicates whether or not the service has been started. If the
service is running, the button label is . Click it to stop the server. If the service
is stopped, the button label is . Click it to start the service.
Under Log Messages
, you will find messages that
the MySQL server produces when it starts or stops. Messages
produced by the server during startup look something like this:
Trying to start the server ... 040119 18:33:41 InnoDB: Started MySql: ready for connections. Version: '4.0.16-max-nt-log' socket: '' port: 3306 Server was started.
When the server stops, it produces messages such as these:
Trying to stop the server ... 040119 18:31:45 MySql: Normal shutdown 040119 18:31:46 MySql: Forcing close of thread 11 user: 'superuser' 040119 18:31:46 MySql: Forcing close of thread 8 user: 'superuser' ... Server was stopped.
The details and format of the messages might vary depending on the version of the MySQL server you are using and its configuration.
Use this tab to configure the Windows service that starts and stops the MySQL server and to set server options This tab is specific to MySQL servers running under operating systems of the Windows NT family, including Windows NT, Windows 2000, and Windows XP; it is not available for servers running under a different operating system. Obviously, you need to have a Windows service installed before you can configure it. See Starting MySQL as a Windows Service, for more information on how to set up a Windows service.
Note that if you have more than one MySQL server running as a Windows service, you should run MySQL Administrator in configure-service mode to administer these services. In normal mode, you can only administer the Windows service listed first in the Windows service manager, no matter which server you are connected to.
Note that the settings in the Server Features group take effect only after restarting the MySQL server.
The following settings are available:
Service Settings
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.
Option File
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:\
). Note
that this is available for MySQL servers as of version
4.0.3 only. See
Creating an Option File, for details
about the server option files.
windows installation
directory
\my.ini
Section Name
:
Setting a value other than mysqld
is
most useful when running multiple servers; see
Running Multiple Servers on Windows.
Server Features
Note that all server features will only take effect after the MySQL server has been restarted.
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.) For more information on
InnoDB tables, see Storage Engines and Table Types.
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.) For
more information on BDB tables, see
Storage Engines and Table Types.
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
Selecting a MySQL Server type.
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 Command Options.
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.