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

[Barry Martin]

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=192.168.4.3 
mythconverg

Enter password:

ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.4.3' (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=192.168.0.3 
mythconverg

Enter password:


Eventually timed out.



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

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

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 
statement.


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.


Thanks!

Barry




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