mysql shutdown

Ok, so I can start mySql from command line, and it is done through a
batch file at system startup.
Now the problem is,
when my batch file tries to close mySql using
D:\MySql0\mysql-5.0.27\bin\mysqladmin -u root -p --port=3307 shutdown,
it hangs at the prompt asking for password.

Is there anyway I can automate it? I have tried passing the password in
the above command but doesn't seem to work.

Any help would be appreciated.

Thanks,
Ozz.


p.s: is installing mysql as service a better option (still using the
non-install zip package)

I found this really cool post online
http://archives.neohapsis.com/archiv...5-q3/1083.html

Answers everything.

Cheers,
Ozz


Ozz wrote:
> Ok, so I can start mySql from command line, and it is done through a
> batch file at system startup.
> Now the problem is,
> when my batch file tries to close mySql using
> D:\MySql0\mysql-5.0.27\bin\mysqladmin -u root -p --port=3307 shutdown,
> it hangs at the prompt asking for password.
>
> Is there anyway I can automate it? I have tried passing the password in
> the above command but doesn't seem to work.
>
> Any help would be appreciated.
>
> Thanks,
> Ozz.
>
>
> p.s: is installing mysql as service a better option (still using the
> non-install zip package)