[mythtv-users] system crashed while setting up mysql database... how to reset??

[jpainter at cox.net]

Was following Jarod's guide, doing well!  Until...

# /sbin/chkconfig mysqld on
# /sbin/service mysqld start 
Set the mysql root password, replacing ROOT_PWD with your chosen administrator password:

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit



I got to the ling for where I was trying to type “quit”

I made 1 mistake, and had horrible misfortune!   I didn’t put my password (stupid, it was late, what can I say), I just typed the line exactly.  Secondly, my machine crashed right when I was about to type quit.  Now, I cant start the service, it just tells me it fails.  

I don’t know how to reset things to try again!

I have searched around, but I don’t really understand mysql at all, I have never used it before.  I tried reinstalling the RPM with –force and that didn’t help anything.