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
I was wondering if these steps can be done using a .bat file?
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')
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