Change MySQl Password Using .bat

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

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')

HTML:

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

 

create a batch file with following lines lets say c:\mysql\abc.bat

cd C:\mysql\bin\
mysql -u root -h 127.0.0.1 -p newpassword

on command prompt type
cd\mysql
abc.bat

Regards

Alex

 

Hi

That directly beings me to the mysql> prompt. Does not change password at all

Thanx

 

make a input.txt file with following lines

set set password = password('new password')
exit

now create a batch file

create a batch file with following lines lets say c:\mysql\abc.bat

cd C:\mysql\bin\
mysql -u root -h 127.0.0.1 <input.txt


cd\mysql
abc.bat

Regards

Alex