2

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 ??

4

Put the path in double quotes "....

|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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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