You can start the MySQL server with the following command:
shell> bin/safe_mysqld &
MySQL uses TCP/IP to connect a client to a server. (This will allow any machine on your network to connect to your MySQL server). Because of this, you must install TCP/IP on your machine before starting MySQL. You can find TCP/IP on your Windows CD-ROM.
Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an old Winsock package! MySQL requires Winsock 2! You can get the newest Winsock from Microsoft. Win98 has as default the new Winsock 2 library, so the above doesn't apply for Win98.
To start the
mysqld server, you should start a MS-DOS window and type:
This will start
mysqld in the background without a window.
You can kill the MySQL server by executing:
C:\mysql\bin\mysqladmin -u root shutdown
Note that Win95/Win98 don't support creation of named pipes. On Win95/Win98, you can only use named pipes to connect to a remote MySQL running on an NT server.
mysqld doesn't start please check whether or not the
`\mysql\mysql.err' file contains any reason for this. You can also
try to start it with
mysqld --standalone; In this case you may
get some useful information on the screen that may help solve this.
The last option is to start
--debug. In this
mysqld will write a log file in `\mysqld.trace'
that should contain the reason why
mysqld doesn't start. If you
make a bug report about this, please only send the lines where something
seams to go wrong to the mailing list!
The Win95/Win98 section also applies to MySQL on NT, with the following differences:
To get MySQL to work with TCP/IP, you must install service pack 3 (or newer)!
For NT, the server name is
mysqld-nt. Normally you should install
MySQL as a service on NT:
(You could use the
mysqld-opt servers on NT,
but those cannot be started as a service or use named pipes.)
You can start and stop the MySQL service with:
NET START mysql NET STOP mysql
Note that in this case you can't use any other options for
You can also run
mysqld-nt as a standalone program on NT if you need
mysqld-nt with any options! If you start
without options on NT,
mysqld-nt tries to starts itself as a service
with the default service options. If you have stopped
have to start it with
NET START mysql.
The service is installed with the name
MySql. Once installed, it must
be started using Services Control Manager (SCM) Utility (found in 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,
can be stopped using
mysqladmin or from the SCM utility or by using
NET STOP MySQL. If you use SCM to stop
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 |
|Cannot Register||Means that the path is incorrect|
If you have problems installing
mysqld-nt as a service, try starting
it with the full path:
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
C:\mysql\bin\mysqld --standalone --debug
The last version gives you a debug trace in `C:\mysqld.trace'.