Take the 2-minute tour ×
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.

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
add comment

1 Answer 1

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. –  BryceAtNetwork23 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
add comment

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.