Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This could be a Rookie problem , but it seems that i am not able to solve it.

I have MySQL server installed on my windows machine(MySQL 5.5) under the Admin username root. Some How i lost the password of MySQL and want to change it , i m going through this link in order to solve it. under c:> mysql-init.txt is :

UPDATE MySQL.user SET Password=PASSWORD('root') WHERE User='root';
FLUSH PRIVILEGES;

and on command line

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld --init-file=C:\\mysql-init.txt

it give an message like 'c:\program' is not recognized as internal or external command.

So basically i am stuck at point 6 of MySQL documentation. any help ??

share|improve this question
up vote 4 down vote accepted

Put the path in double quotes "....

share|improve this answer
1  
That's the problem with spaces in directory names. Anytime you want to work with them from the command line, it's a pain. – Aaron Apr 25 '12 at 12:55
    
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --init-file=C:\\mysql-init.txt. this works for me .... thanks – vibhor Apr 25 '12 at 12:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.