Results 1 to 2 of 2
Thread: MySQL Corrupted
Enjoy an ad free experience by logging in. Not a member yet? Register.
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--
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;
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)
[MythTV@localhost ~]$ mysql -u root mysql -poodle
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Join Date
- Dec 2006
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