MySQL Corrupted

Hola,
I've spent a good week working to set up MythTV on my Fedora Core 7 computer, but I am still unable to set up the MySQL server correctly. I've followed the following instructions over and over again, and I've also reinstalled MySQL and MythTV, but still no success. Could someone tell me how to delete every trace of MySQL and start from scratch? Here are the instructions I followed--

Quote:

---

12. Set up MySQL

We'll need to enable MySQL to load at startup, set some passwords, and create the MythTV database, which we'll populate shortly. The population of this database is handled by mythtvsetup in the next step, and all MythTV add-on module database additions must be done AFTER running mythtvsetup at least one time.
# /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

Now we create the mythtv database (called mythconverg) to get us started:
$ mysql -u root -p < /usr/share/doc/mythtv-0.20/database/mc.sql
(enter the password you just set above when prompted)

---

I continually run into this error--

Quote:

---

[MythTV@localhost ~]$ mysql -u root mysql -poodle
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

---

I'd deeply appreciate any help. Thanks a million!

If you installed MySQL via yum, then:

yum remove mysql*

Should remove all traces of it; but you probably don't need to do that.

I have had much success using -p<password> with the mysql cli. Maybe try:

mysql -u root -p

instead, and then enter the password when prompted.

IIRC, --password=<password> did work for me, eg:

mysql -u root --password=something