Running MySQL as a Service Under Windows NT

Table of Contents

• Introduction
• Installing MySQL as a Service
• Controlling the MySQL Service
  • Controlling the Service From the Command Line
  • Controlling the Service Using the Services Manager
• Removing the MySQL Service
• Acknowledgment

When you maintain a MySQL installation, normally you want the MySQL server to run all the time. You can start the server by invoking it yourself, but if the machine restarts, MySQL availability is interrupted until you remember to start the server again. Under operating systems that allow you to modify the system startup procedure, you can include a step that launches your MySQL server. That way, the server runs without intervention on your part even in the event of an unattended machine restart. You can achieve this under Windows NT by installing MySQL as a service that is set to run automatically. NT's service management facilities also allow you to control the service manually if necessary--for example, to stop the service to perform administrative tasks with the server down, then start it again afterward.

The discussion in this article uses "Windows NT" as a generic term that also applies to other NT-based systems, such as Windows 2000 and XP. It does not apply to versions of Windows that do not support services, such as Windows 95, 98, or Me.

If MySQL is not already installed on your system, you can download it from the MySQL AB web site:

   http://www.mysql.com/

To install a MySQL server as a service under Windows NT, invoke it with the --install option from the command line. For example, to install mysqld-nt this way, use the following commands:

   C:\> mysqld-nt --install
   C:\> NET START MySql

When you install a MySQL server as a service from the command line, normally only the --install option is used. You cannot specify runtime options on the commmand line because you don't invoke the server directly from the DOS prompt. To specify options that the server should use each time it runs thereafter, you must place them in an option file instead. Suppose you want the server to start as though you'd given the --flush and --log=query-log options on the command line. To achieve the same effect using an option file, add the options, one per line, to the [mysqld] group in the file:

   [mysqld]
   flush
   log=query-log

A MySQL server that has been installed as an automatic service is run by NT's service management facilities each time the machine starts up. Those facilities also allow you to start or stop the server manually or to check its status. These operations are available both at the command line and through the graphical interface provided by the Services Manager.

Controlling the Service From the Command Line

To start or stop the MySQL service from the command line, use these commands:

   C:\> NET START MySql
   C:\> NET STOP MySql

   C:\> NET START

   C:\> mysqladmin -p -u root shutdown

To control the server using a graphical interface, launch the Services Manager. You can find this as the Services item in the Control Panel or in the Administrative Tools item in the Control Panel. The Services Manager displays information like that shown in Figure 1. (Your particular version may have a somewhat different appearance.)

Figure 1. The Services Manager

The MySQL service line will contain the word Started if the server is running, and also includes the service startup mode. The mode is either Automatic (service runs automatically as part of the system startup procedure), Manual (service is started manually), or Disabled (service does not run at all).

To control the MySQL service, select the MySQL line from the service list on the left side of the Services window, then click the appropriate button:

• To stop a running service, select the MySQL line and click the Stop button.
  
• To start the service, select the line and click the Start button.
  

If you perform service operations from the command line while the Services Manager is running, it will not notice the effect of those operations. For example, if you install or remove the MySQL service by invoking a server with the --install or --remove options, Services Manager doesn't update its service list. Similarly, if you run commands such as NET START or NET STOP at the DOS prompt, Services Manager doesn't notice changes to the service status. To avoid confusion, close Services Manager before performing service operations from the command line, then reopen it. That way, information that the Services Manager displays will be up-to-date.

Removing the MySQL Service

If you decide you no longer want to run MySQL as a service, remove it by invoking the server with the --remove option. However, before you do this, you should stop the server if it's currently running. For example, if you installed mysqld-nt, stop it and remove it like this:

   C:\> NET STOP MySql
   C:\> mysqld-nt --remove

   C:\> NET STOP MySql
   C:\> mysqld-nt --remove
   C:\> mysqld-max-nt --install
   C:\> NET START MySql

The original version of this article was written for NuSphere Corporation. The current version is an updated revision of the original.