[mythtv-users] what in the world is going on with database password??

[Bill Meek]

On 10/30/18 10:01 PM, James Abernathy wrote:
> I’m now having problems with mythtv-setup not connecting to the database.  I’m following the instructions I documented in the following blog:
> 
> https://mythtvinstall.blogspot.com/2018/10/creating-mythtv-v29-frontendbackend-on.html
> 
> The first time I did this, no problems.  I complete started over again to verify things. Since I link /etc/mythtv/config.xml to $HOME/.mythtv/config.xml before I run mythtv-setup, I never had to look at the database password.

To be clear, ~mythtv/.mythtv/config.xml and ~/.mythtv/config.xml are linked to /etc/mythtv/config.xml
not the other way around. Your blog has the correct format.

> I ran mythtv-setup after setting up XMLTV json per the wiki as I’ve done before and documented.  I had no problems connecting then, but after I finished, I ran mythfilldatabase and it also bombed due to not connecting with the database.  I tried mythtv-setup again and this time it couldn’t connect.
> 
> It’s like I follow the same instructions, but it randomly fails.
> 
> when I run mythfilldatabase now I see this:
> 
> 2018-10-30 22:57:55.639274 I  Start up testing connections. DB 192.168.0.251, BE , attempt 0, status dbAwake
> 2018-10-30 22:57:56.641275 I  Start up testing connections. DB 192.168.0.251, BE , attempt 1, status dbAwake
> 2018-10-30 22:58:01.650478 I  Start up testing connections. DB 192.168.0.251, BE , attempt 2, status dbAwake
> 2018-10-30 22:58:06.659712 I  Start up testing connections. DB 192.168.0.251, BE , attempt 3, status dbAwake
> 2018-10-30 22:58:11.668891 I  Start up testing connections. DB 192.168.0.251, BE , attempt 4, status dbAwake

1st, remove MythTV from the picture:

     mysql --host=localhost --user=mythtv --password=yourPasswordHere mythconverg

If that fails, it's a DB configuration issue.

If it works, then I'd start here: https://www.mythtv.org/wiki/Config.xml#Troubleshooting

-- 
Bill