LinuxMCE Forums

General => Installation issues => Topic started by: nite_man on February 03, 2008, 09:31:26 PM

Title: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: nite_man on February 03, 2008, 09:31:26 PM
Hi,

Try to play with 0710 beta 3 and have a problem with mythtv. It says
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?
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: nite_man on February 03, 2008, 09:35:15 PM
Moreover, mythweb also doesn't work anymore because access to the database is denied.
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: domotiqa.com on February 04, 2008, 09:27:03 PM
I have the same problem, I'm looking forward !!
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: juargin on February 05, 2008, 07:29:12 AM
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.
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: nite_man on February 05, 2008, 10:10:10 AM
Thanks a lot, juargin! I think that my problem is similar to your. I'll try to fix it according to your suggestions tonight.
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: domotiqa.com on February 05, 2008, 02:59:59 PM
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 !
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: nite_man on February 05, 2008, 08:45:00 PM
I grant permissions as juargin suggested and now mythtv starts ok.
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: infaze3 on February 26, 2008, 05:52:39 AM
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
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: Zaerc on February 26, 2008, 05:21:47 PM
Quote from: domotiqa.com on February 05, 2008, 02:59:59 PM
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. 

Quote from: infaze3 on February 26, 2008, 05:52:39 AM
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.
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: infaze3 on February 28, 2008, 09:12:55 PM
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
Title: Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
Post by: orionsune on February 29, 2008, 12:32:03 AM
sudo vi /etc/mythtv/mythweb-htaccess
gives you access denied?