<html><head></head><body><div>On Sun, 2020-10-18 at 21:38 -0400, Mary Strimel wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div dir="ltr">hi, <div>I have freshly installed mythtv system on my Linux Mint PC. I installed the available packages from my distro, myth version 31. </div><div><br></div><div>The local frontend works fine. However, the frontend that I installed on my Android TV -- also version 31 -- is unable to connect. At first it saw the database and was unable to connect to it. After trying some of the fixes I read about online, now it doesn't see the database at all. </div><div><br></div><div>Here are the things I've tried:</div><div>1. went to mythbackend-setup and set the IP address to my real address instead of 127.0.0.1</div><div>2. verified that the PIN for remote logon is set to 0000</div><div>3. verified that the mysql password on the Android is the same as the one found in /home/mythtv/.mythtv/config.xml</div><div>4. Attempted to tell sql to allow the remote connection.</div><div> A. At first I used the command </div><div>"grant all on mythconverg.* to 'mythtv'@'%' identified by 'mypassword';"</div><div><br></div><div>then I got an error because apparently that command is now deprecated. </div><div><br></div><div>B. So I tried GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv" PASSWORD "mypassword" which did not report an error, but also didn't give any feedback. In fact it made the mysql prompt look funny, so I'm assuming it was unhelpful?</div><div><br></div><div>5. I then went to /etc/mysql/my.cnf. According to the docs I should be commenting out a particular line regarding networking. However, my file didn't have those lines. It did not have sections either, like other peoples' seem to have. It just had two lines that start with "!includedir". I didn't change anything there.</div><div><br></div><div>6. As a last resort I went to /etc/mysql/conf.d/mythtv.cnf and changed the first line to "bind-address=192.168.1.253" [my IP]. I think this last step might have been wrong.</div><div><br></div><div>What else do I need to do to connect my frontend? Should I undo things I tried above?</div><div>Thank you!</div><div>Mary</div><br></div><div>_______________________________________________<br></div><div>mythtv-users mailing list<br></div><div><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br></div><div><a href="http://email.mg.glenb.net/c/eJxNjksKwyAYhE8TdxWN74WLbHoPX38iqCnRFnr7pqXQwmzmmxmYaAO4KDjKNmoHLoHgioEIYIyWUSmtPFBIyQjPBJgoCQ6upjJxspbUPG5poM0aJgh13DMClHsFQQsJMwWqA6dGzqjYbYzbxJZpvp4quY-O63Ns44H3Yz1RdblU175hbrC_4adxufd0dHTYf3s--O1fD2RA2Q">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br></div><div><a href="http://email.mg.glenb.net/c/eJxFjbsOgkAQRb-G7dwszj6g2MLGSr-B7GMGNgIqDBr_XhILk1udnJObfaKQjRbF5yZQQDLaAZlEbdvY7FzjItWE2JoIhtpslUxhwrHSqh9xjnJGFoM3pG0Dqc4Qgo5ANild2wjWgFYKQIx-YH5UcKqO533vcity-vDAL3lf-p1cQxnL3HeXsnKHXJ4bMqNY_M86bCsu6_76j74v0jy3">http://wiki.mythtv.org/Mailing_List_etiquette</a><br></div><div>MythTV Forums: <a href="http://email.mg.glenb.net/c/eJxFjMsKwyAQAL8m3ipG3bgePPTS_9DsblLIoxhT6N830ENhLsPAUBolE3j1TIRZMgv44ARGiREHCgFDkV6YIxQHEmkweswrL50308Jb0Rs3NSdGjoyWojEswZkCxg3WIWC01HtWS5pbex2du3f2cSF7PVe9ftrc3nqvk6rpJ7fz4Hpc-3_7AjG_NC8">https://forum.mythtv.org</a><br></div></blockquote><div><br></div><div>make sure the port is open, no firewall blocking it, or if firewall open the port.</div><div>on the mysql privleges try : GRANT ALL ON mythconverg.* TO <a href="mailto:mythtv@localhost">mythtv@192.168.1.%</a> </div><div>try adding the bind address to my.cnf, and for me it always by making it 0.0.0.0</div><div><br></div><div class="-x-evo-signature-wrapper"><span class="-x-evo-signature" id="none"></span></div><img width="1px" height="1px" alt="" src="http://email.mg.glenb.net/o/eJwlyzsOwjAMANDTkI0of8dDDuPUdovUFikNSNweJMY3PG6LEudkHo0rKYnmBFHzooi1MECFrl5FMPeYFbk4u9Ah-y25dZez21Om2Vp0FCJwSBVzQGBBX8GH4JwU8pXMaMdnbvN9f10yrt_-0z7H-gU7Hihx"></body></html>