[mythtv-users] New IP address not used by Database

Barry Martin Barry_Martin_3 at Q.COM
Mon Jun 22 00:03:27 UTC 2020

Hi Bill!

>      mysql --user=mythtv --password --host=<your DB IP or hostname> mythconverg
> Retry with: --host=localhost if the IP address was used please.

(1) First command line’s results:

barry at Backend-3:~$ mysql --user=mythtv --password --host= 

Enter password:

ERROR 1045 (28000): Access denied for user 'mythtv'@'' (using 
password: YES)

barry at Backend-3:~$

I'll assume "password: Yes" means it is being used as it asked for it.

(1a) OK, maybe stupidly put in the address the database seems to think 
it wants: (The original IP)

barry at Backend-3:~$ mysql --user=mythtv --password --host= 

Enter password:

Eventually timed out.

(2) The second “Retry” command line result:

barry at Backend-3:~$ mysql --user=mythtv --password --host=localhost 

Enter password:

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 1356

Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 

MariaDB [mythconverg]>

OK, that looks semi-promising. Typed 'exit' as I no instructions on what 
to do next. Well, while I’m in the database; I do have this to do:

> Remove ~/.mythtv/config.xml and link it to the one in /etc:
>     ln -s /etc/mythtv/config.xml ~/.mythtv/config.xml

Checked and “etc’s” has host=localhost. (Just verifying before doing! 
Not that I don’t trust but want to make sure we’re not accidentally 
creating a bigger problem.)

ls ~/.mythtv/config.xml ==> now is light blue on black, so must be the 
“I’m a link” colour. cat /home/barry/.mythtv/config.xml looks good.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200621/b1667fe3/attachment.htm>

More information about the mythtv-users mailing list