I have WindowsXP 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 hostn ame changed!! Please use '--relay-log=varuna-e2a34b74-relay-bin' to avoid this p roblem. 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 Edition (GPL) 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 mysqld-debug Varuna