PDA

View Full Version : MythTV - Cannot login to database?



Sershy
February 1st, 2009, 12:18 PM
Hello

I just installed MythTV on a Ubuntu 8.04 64-bits, but when I try to run the backend setup I get an error saying "Cannot login to database?". I have no idea what to do, and I haven't found the answer googling either.

ianhaycox
February 1st, 2009, 12:36 PM
Try this:



$ source /etc/mythtv/mysql.txt
$ mysql -u$DBUserName -p$DBPassword $DBName


and see if it connects to the database or report any errors back.

Sershy
February 1st, 2009, 12:46 PM
When I type the Mysql command in the console I get an error saying "Error 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)"

ianhaycox
February 1st, 2009, 12:56 PM
Looks like your password is wrong, hopefully following this should fix it

https://help.ubuntu.com/community/MythTV/Install/Troubleshooting

You may need to restart mysql and/or mythtvbackend once the password is reset.

You may have guessed but the password is in /etc/mythtv/mysql.txt so you can hack that and mysql by hand if you like.

Sershy
February 1st, 2009, 01:19 PM
My password is correct according to the mysql.txt, but I still get an error.

ryansebiz
February 22nd, 2009, 06:14 AM
I'm having the same problem.

How do you open mysql.txt?

ianhaycox
February 22nd, 2009, 10:26 AM
$ sudo gedit /etc/mythtv/mysql.txt