LinHES Forums
http://forums.linhes.org/

Database error was: Access denied for user 'mythtv'@'mythtv'
http://forums.linhes.org/viewtopic.php?f=21&t=24412
Page 1 of 1

Author:  rsay [ Sat Sep 24, 2016 6:48 am ]
Post subject:  Database error was: Access denied for user 'mythtv'@'mythtv'

Somehow I have brought down my backend on 8.4.1 and I can't figure out how to get it back up. Everything was running well. I attempted to configure a static IP address in the linhes service menu. The static IP address was exactly the same as the DHCP address except I wanted to change the dns server. Here are a few things that I have checked:

Code:
mysql -u mythtv -p

allows me to login without a problem.

/etc/hosts shows:
Code:
127.0.0.1 localhost
192.168.1.130 mythtv


/etc/resolv.conf shows:
Code:
search local
nameserver 192.168.1.1

(Which incidentally is not the nameserver I tried to configure, but the one that I was using successfully before I attempted the change.

In mythtv-setup I see:
Hostname 192.168.1.130
Port: 3306
Database: mythconverg
user: mythtv
password:mythtv

Code:
ip addr show dev eth0

inet 192.168.1.130/24 brd 192.168.1.255 scope global eth0

the only other thing that I attempted during this session was to install google chrome
Code:
pacman -S google-chrome


Code:
dhcpcd eth0

I tried the above command and then attempted to restart the backend but I got the same error


Any ideas on how to get things running again?

Author:  rsay [ Wed Sep 28, 2016 11:31 am ]
Post subject:  Re: Database error was: Access denied for user 'mythtv'@'myt

31 views without a response. I'll take that as a signal that it's time to re-install clean and restore my backup. If I manage to recreate the problem, I'll let you know.

Author:  mattbatt [ Wed Sep 28, 2016 8:30 pm ]
Post subject:  Re: Database error was: Access denied for user 'mythtv'@'myt

I don't have my myth box near me. Why are you putting a computer named mythtv in the hosts file of your mythtv computer. For example my hostname for my Fe/be linhes box is Gimli my other front-end is Frodo, I don't think I want to put Gimli's address in the hosts file on Gimli.
Did you configure your router to set the static IP for your mythtv box?

Author:  brfransen [ Thu Sep 29, 2016 7:43 am ]
Post subject:  Re: Database error was: Access denied for user 'mythtv'@'myt

Since you are able to login to mysql from the command line check all the .config.xml files.
/usr/share/mythtv/config.xml
/home/mythtv/.mythtv/config.xml
/root/.mythtv/config.xml

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/