[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=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>
More information about the mythtv-users
mailing list