service usually indicates a background service such as Windows Service
MySQL implements Windows Service Functionality thru
mysqld-nt binary documentation is available at
a server is a standalone binary or even possibly a binary acting in concert with assocated
or possibly a permutation of java jars containing a main
to start mysql as a standalone (non-service) server execute
documentation is located at
if you believe you have a misconfiguration in %MYSQL_HOME%, %PATH%
or even possibly my.ini configuration settings
you would use the debug option for the server such as what is shown here
documentation on this attribute is scarce and is mostly used by mysql engineers but this
may be helpful
concerning configuration files such as my.ini based I would use the templates found at
05/30/2008 08:17 PM 4,954 my-huge.ini
05/30/2008 08:17 PM 21,204 my-innodb-heavy-4G.ini
05/30/2008 08:17 PM 4,931 my-large.ini
05/30/2008 08:17 PM 4,938 my-medium.ini
05/30/2008 08:17 PM 2,469 my-small.ini
in other words for ISAM small database requirement
ren my-small.ini to my.ini
ensure my.ini is placed on %PATH%
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission.
> Date: Sat, 4 Oct 2008 17:33:06 +0530
> From: varunawithmysql@stripped
> To: mysql@stripped
> Subject: How to start mysqld server, What is the difference between a server and a
> Hello Every body!
> I stopped the service from the services shortcut in the Administrative
> tools.then according to to the reference manual to start the server for the
> first time the command to run is given as C:\>"C:\Program Files\MySQL\MySQL
> Server 5.0\bin\mysqld" --console
> But it didn't work, the following was the displayed message
> '"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"' is not recognized as
> an i
> nternal or external command,
> operable program or batch file.
> *But when I used "mysqld-nt" The following is the out put*
> C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --console
> 081004 16:56:01 InnoDB: Started; log sequence number 0 43655
> 081004 16:56:01 [Warning] Neither --relay-log nor --relay-log-index were
> used; s
> o replication may break when this MySQL server acts as a slave and has his
> ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid
> this p
> 081004 16:56:01 [Note] C:\Program Files\MySQL\MySQL Server
> 5.0\bin\mysqld-nt: re
> ady for connections.
> Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community
> 1 In the reference manual there are three server types how can I start the
> mysqld server?
> 2 What is the difference between installing MySQL as a server and a service,
> Is it only that when installed as a service MySQL server starts when Windows
> starts and when Windows stops it stops?
> 3 After starting the server in above mentioned way How can I use MySQL
> server Do I have to open another console window and do what?
> 4 In Windows is it not possible to start other to two servers mysqld and
> Thanks Varuna
See how Windows connects the people, information, and fun that are part of your life.