...

View Full Version : Change MySQl Password Using .bat



phantom007
02-26-2009, 10:55 AM
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')


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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum