Hi

First of all I am sorry if I am posting in a wrong section.

Following are the steps to change MySQL root password using command prompt

Code:
1) cd C:\mysql\bin\
2) mysql -u root -p mysql -h 127.0.0.1
3) (when prompting for password) we enter password
4) set password = password('new password')
I was wondering if these steps can be done using a .bat file?

If yes how?

I have tried creating a .bat file with the above steps but it stucks at line when it prompts for the password. can I automate it as well?


Thanx for your help