Meph1st0
January 6th, 2008, 12:42 PM
I can't remember the SQL database password from when I installed mythbuntu. The reason why I need it is because I think I need to do a repair on the database. My scheduling information is lost. I went to mythweb and got the following error:
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
SQL Error: Table './mythconverg/oldrecorded' is marked as crashed and should be repaired [#145]
So I'm trying to run the following command to repair my database but it's asking me for my password.
mysqlcheck --repair -umythtv -p mythconverg
I've tried my root password but it didn't work, I get the following error:
mysqlcheck: Got error: 1045: Access denied for user 'mythtv'@'localhost' (using password: YES) when trying to connect
I've seen posts where people have had to create a new database but I don't want to do that because I don' t want to have to reinput all of my recording preferences and such.
If I can't get my sql database password, then is there an easy way to restore a backup? I remember reading a post saying that Mythbuntu automatically saves backups of the database.
Fatal Error at /usr/share/mythtv/mythweb/includes/objects/Database_Query_mysql.php, line 73:
SQL Error: Table './mythconverg/oldrecorded' is marked as crashed and should be repaired [#145]
So I'm trying to run the following command to repair my database but it's asking me for my password.
mysqlcheck --repair -umythtv -p mythconverg
I've tried my root password but it didn't work, I get the following error:
mysqlcheck: Got error: 1045: Access denied for user 'mythtv'@'localhost' (using password: YES) when trying to connect
I've seen posts where people have had to create a new database but I don't want to do that because I don' t want to have to reinput all of my recording preferences and such.
If I can't get my sql database password, then is there an easy way to restore a backup? I remember reading a post saying that Mythbuntu automatically saves backups of the database.