<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV><DIV>On Aug 2, 2006, at 3:12 PM, Thomas Repetti wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I recently changed my broadband provider and had to change my in-house IP</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">subnet.<SPAN class="Apple-converted-space"> </SPAN>Since then, I have been unable to use Tapeworm to connect to the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">SQL server and display the list of movies on disk.<SPAN class="Apple-converted-space"> </SPAN>I did a sniffer trace,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">and the error is:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Host 'dad-1.107es.com' is not allowed to connect to this MySQL server</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I did not think that the accounts on the SQL server were tied to the subnet,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">but I must think that this is a possibility.<SPAN class="Apple-converted-space"> </SPAN>So.....2 questions.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">1 - Is there an easy fix for this?<SPAN class="Apple-converted-space"> </SPAN>Is so, can someone step me through it,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">2 - I have considered a rebuild of the system.<SPAN class="Apple-converted-space"> </SPAN>All my video is on a</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">separate volume, and I was thinking I could back up my existing database,</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">rebuild the MythTV server, reload the database from backup, and re-mount the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">video directory.<SPAN class="Apple-converted-space"> </SPAN>Part of me thinks I might reintroduce the problem if it is</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">caused by a db record, but I'd be willing to try.<SPAN class="Apple-converted-space"> </SPAN>At worst it would bring</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">me right back to the original problem, and at best it would give me</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">experience in a bare-metal restore of the MythTV server.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Thanks</DIV></BLOCKQUOTE></DIV><BR><DIV>MySQL permissions are specific to the host from which you are connecting unless you specify % as the host you're allowing connections from. In the MySQL client (as root user), you need to issue a command like this:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier">mysql> </FONT><FONT class="Apple-style-span" face="Courier">GRANT ALL PRIVILEGES ON *.* TO USER@"%"</FONT><FONT class="Apple-style-span" face="Courier"> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;</FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><FONT class="Apple-style-span" face="Courier"><BR class="khtml-block-placeholder"></FONT></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">This means that the user named USER from any host (that's what the % is) with the password of some_pass may connect and alter any database/table. If you want to secure this a bit more, specify your new hostname instead of % and GRANT ALL PRIVILEGES ON mythconverg.* so the user may alter any table on only the mythconverg database.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">-Brad</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV></BODY></HTML>