GNU Info

(mysql.info)NT start

---

Next: Windows running Prev: Win95 start Up: Windows

---

Enter node , (file) or (file)node

Starting MySQL on Windows NT or Windows 2000
............................................

The Win95/Win98 section also applies to MySQL on NT/Win2000, with the
following differences:

To get MySQL to work with TCP/IP on NT, you must install service pack 3
(or newer)!

Note that everything in the following that applies for NT also applies
for Win2000!

For NT/Win2000, the server name is `mysqld-nt'.  Normally you should
install MySQL as a service on NT/Win2000:

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

or

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

(Under Windows NT, you can actually install any of the server binaries
as a service, but only those having names that end with `-nt.exe'
provide support for named pipes.)

You can start and stop the MySQL service with these commands:

     C:\> NET START mysql
     C:\> NET STOP mysql

Note that in this case you can't use any other options for `mysqld-nt'!

You can also run `mysqld-nt' as a stand-alone program on NT if you need
to start `mysqld-nt' with any options!  If you start `mysqld-nt'
without options on NT, `mysqld-nt' tries to start itself as a service
with the default service options.  If you have stopped `mysqld-nt', you
have to start it with `NET START mysql'.

The service is installed with the name `MySQL'. Once installed, it must
be started using the Services Control Manager (SCM) Utility found in the
Control Panel, or by using the `NET START MySQL' command.  If any
options are desired, they must be specified as "Startup parameters" in
the SCM utility before you start the MySQL service.  Once running,
`mysqld-nt' can be stopped using `mysqladmin', or from the SCM utility
or by using the command `NET STOP MySQL'. If you use SCM to stop
`mysqld-nt', there is a strange message from SCM about `mysqld shutdown
normally'.  When run as a service, `mysqld-nt' has no access to a
console and so no messages can be seen.

On NT you can get the following service error messages:

Permission Denied      Means that it cannot find `mysqld-nt.exe'.
Cannot Register        Means that the path is incorrect.
Failed to install      Means that the service is already installed or
service.               that the Service Control Manager is in bad state.

If you have problems installing `mysqld-nt' as a service, try starting
it with the full path:

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

If this doesn't work, you can get `mysqld-nt' to start properly by
fixing the path in the registry!

If you don't want to start `mysqld-nt' as a service, you can start it as
follows:

     C:\> C:\mysql\bin\mysqld-nt --standalone

or

     C:\> C:\mysql\bin\mysqld --standalone --debug

The last version gives you a debug trace in `C:\mysqld.trace'.  Note:
Making trace files.