I recently installed sugarcrm from the FastStack Windows Installer for 5.2.0c with MySQL
Install the complete Open Source stack (Apache, MySQL, PHP) with Sugar Community Edition already included.

A few weeks after installation I lost the password and tried to reset it using a modified version of the instructions listed here: http://dev.mysql.com/doc/refman/5.0/...rmissions.html

The actual command that I used was: "mysqld.exe --defaults-file ="c:\program files\sugarcrm-5.2.0c\mysql\my.ini" --init-file=c:\mysql-init.txt"

The contents of the mysql-init.txt file was: "UPDATE mysql.user SET Password='pword' WHERE User='root';
FLUSH PRIVILEGES;

I've since been shown a very easy way to recover the password, so I know that I'm using the right username and password, but whenever I now try to start the sugarMysql service I receive the following error:

Could not start the sugarMysql service on Local Computer
Error 1067: The process terminated unexpectedly.

Can anyone help me "undo" whatever the dos command did? Sugar was working perfectly before I executed it. Thanks so much.