Author Topic: Access denied for user 'mythtv'@'localhost' (using password: YES)  (Read 6084 times)

nite_man

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1019
  • Want to work with LinuxMCE
    • View Profile
    • Smart Home Blog
Hi,

Try to play with 0710 beta 3 and have a problem with mythtv. It says
Code: [Select]
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?
Michael Stepanov,
My setup: http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup
Russian LinuxMCE community: http://linuxmce.ru

nite_man

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1019
  • Want to work with LinuxMCE
    • View Profile
    • Smart Home Blog
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #1 on: February 03, 2008, 09:35:15 pm »
Moreover, mythweb also doesn't work anymore because access to the database is denied.
Michael Stepanov,
My setup: http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup
Russian LinuxMCE community: http://linuxmce.ru

domotiqa.com

  • Guru
  • ****
  • Posts: 206
    • View Profile
    • home automation
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #2 on: February 04, 2008, 09:27:03 pm »
I have the same problem, I'm looking forward !!
http://www.domotiqa.com - home automation

juargin

  • First post!
  • Posts: 1
    • View Profile
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #3 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.

nite_man

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1019
  • Want to work with LinuxMCE
    • View Profile
    • Smart Home Blog
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #4 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.
Michael Stepanov,
My setup: http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup
Russian LinuxMCE community: http://linuxmce.ru

domotiqa.com

  • Guru
  • ****
  • Posts: 206
    • View Profile
    • home automation
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #5 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 !
http://www.domotiqa.com - home automation

nite_man

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1019
  • Want to work with LinuxMCE
    • View Profile
    • Smart Home Blog
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #6 on: February 05, 2008, 08:45:00 pm »
I grant permissions as juargin suggested and now mythtv starts ok.
Michael Stepanov,
My setup: http://wiki.linuxmce.org/index.php/User:Nite_man#New_setup
Russian LinuxMCE community: http://linuxmce.ru

infaze3

  • Making baby steps
  • Posts: 3
    • View Profile
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #7 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

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #8 on: February 26, 2008, 05:21:47 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. 

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.
"Change is inevitable. Progress is optional."
-- Anonymous


infaze3

  • Making baby steps
  • Posts: 3
    • View Profile
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #9 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

orionsune

  • Veteran
  • ***
  • Posts: 133
    • View Profile
Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« Reply #10 on: February 29, 2008, 12:32:03 am »
sudo vi /etc/mythtv/mythweb-htaccess
gives you access denied?
entia non sunt multiplicanda praeter necessitatem