Could not start the mysql service on localcomputer :Error 1067

[TechnoAtif]

Could not start the mysql service on localcomputer
Error 1067:The process terminated unexpectedly.
------------------------------------------------------------------------------

Hi All. I 'm facing a problem while working with mysql. Plz help.
I have got Apachephpmysql1.1 installed in my computer. It does not require any password to start mysqlmonitor. but i wanted it to prompt for a passsword.So i went through the following procedure:

1)I stopped the mysql service from the control panel

2)Then created a mysql-ini.txt file and typed the following command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxl');

3)At the DOS command prompt, execute this command:

C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt

but cursor was not blinking for a long time on pressing enter. I thought the DOS has got hung and i closed the dos monitor abruptly.

4)Next i executed a .php file but it says
' Unable to connect to the database server at this time'.
5) I realized that the mysql service is not started yet. so i started it.
But it prompts the message:
---------------------------------------------------------------------------

Could not start the mysql service on localcomputer
Error 1067:The process terminated unexpectedly.

--------------------------------------------------------------------------
I think that this error is due to the abrupt stopping of dos.

But now 'm not able to find any solution for this. I was doing smoothly with php.
But this problem has halted all my progress as well as project.

Please help if anyone can. Thanx

[pbmods]

Heya, Techno.

I'm going to go ahead and move this thread to the MySQL forum, where our resident Experts will be better able to help you out.