O'Reilly logo

Managing & Using MySQL, 2nd Edition by Hugh E. Williams, Randy Yarger, George Reese, Tim King

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Windows NT/2000 Startup

On Windows NT, you should have at least service pack 3 to get the right level of TCP/IP support for MySQL.

We recommend that you run the MySQL server as an NT service. The simplest way to install MySQL as a service is to use the winmysqladmin.exe utility that comes with a Windows installation of MySQL. You can use this tool to configure MySQL and install it as a service.

To install MySQL as a service by hand, open up an MS-DOS window and type:

C:\> c:\mysql\bin\mysqld-nt -install

This will create an NT service called MySQL. This service is now available from the Services control panel. To access this, open your control panel and double-click on the Services icon.[1] Figure 2-1 shows the Services control panel from a Windows NT box with MySQL installed as a service.

A Windows NT Services control panel with MySQL installed
Figure 2-1. A Windows NT Services control panel with MySQL installed

Now you can start MySQL by clicking on the Start button. If you would like to change the command-line options for the MySql service, you can type them in the Startup Parameters text box before starting the service. In Figure 2-2, after the service has started, the status shows as Started.

The Started MySQL service
Figure 2-2. The Started MySQL service

To stop the service, click on Stop. You can also start and stop the service from an MS-DOS prompt using the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required