Access denied for user 'mythtv'@'localhost' (using password: YES)

[nite_man]

Hi,

Try to play with 0710 beta 3 and have a problem with mythtv. It says

Code:

Access denied for user 'mythtv'@'localhost' (using password: YES)

I suspect that it cause the problem with rebuilding MD image. The process waits something. According to Dan's post it might be because router is locked by mythbackend starting script.

BTW, I choose VDR as a media center. Why router tried to run mythtvbackend?

[nite_man]

Moreover, mythweb also doesn't work anymore because access to the database is denied.

[domotiqa.com]

I have the same problem, I'm looking forward !!

[juargin]

I had the same problem. It appeared as if the upgrade (I used the amd64 dvd to upgrade from i386 704) did not fully register the myth password. I fixed it by changing the password used by mythtv in the following places:

On the command line, log in to mysql and run the following commands (changing 'password' to something else.):
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by "password";
mysql> flush privileges;

mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by "password";
mysql> flush privileges;

Then edit /etc/mythtv/mysql.txt and change the following line:
DBPassword=password
replacing the 'password' with your selected password.

And finally edit /etc/mythtv/mythweb.htaccess and change the following line:
setenv db_password     "password"
again replacing the 'password' with your password.

Finally reboot the system. This jump started mythtv and allowed mythweb to work as well for me.

[nite_man]

Thanks a lot, juargin! I think that my problem is similar to your. I'll try to fix it according to your suggestions tonight.

[domotiqa.com]

When I'm starting mythtvbackend from the Kde menu, I have to choose the langage, then the db parameters for my sql db !
I put root and blank password, and everything goes well now !

[nite_man]

I grant permissions as juargin suggested and now mythtv starts ok.

[infaze3]

Juargin

Why can't I find the file mythweb.htaccess?

"And finally edit /etc/mythtv/mythweb.htaccess and change the following line:"

In the /mythtv/ folder there is a file mythweb-htaccess but file type is unknown.

Any suggestions?

Thanks

710B3 DVD installation, ASUS M2N-VM, AMD 4400X2, Hdhomerun

[Zaerc]

When I'm starting mythtvbackend from the Kde menu, I have to choose the langage, then the db parameters for my sql db !
I put root and blank password, and everything goes well now !

Eventhough that works, it is not the correct way to fix this problem. 

Juargin

Why can't I find the file mythweb.htaccess?

"And finally edit /etc/mythtv/mythweb.htaccess and change the following line:"

In the /mythtv/ folder there is a file mythweb-htaccess but file type is unknown.

Any suggestions?

Thanks

710B3 DVD installation, ASUS M2N-VM, AMD 4400X2, Hdhomerun

I only see a "mythweb-htaccess" as well, try editing that one instead.  Maybe "mythweb.htaccess" was changed recently or it could have been a type-o, I don't know.

[infaze3]

When I try to edit /etc/mythtv/mythweb-htaccess I am denied permission.
I am using a fresh install so the passwords should be default.
Can you suggest how I can get the permissions to edit this file?

Thanks

[orionsune]

sudo vi /etc/mythtv/mythweb-htaccess
gives you access denied?