View Full Version : Change MySQl Password Using .bat

02-26-2009, 10:55 AM

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

1) cd C:\mysql\bin\
2) mysql -u root -p mysql -h
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