<div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I'm starting to think about access permissions on my remote backend<br>mysql or maybe my backend database doesn't know its real host name. I
<br>think I can feel the water reaching my chin. Boy am I seriously out of<br>my depth.<br>Mal<br><br>[new extract of new log]<br>2006-10-16 22:49:55.332 Using runtime prefix = /usr<br>2006-10-16 22:49:55.355 DPMS is active.
<br>2006-10-16 22:49:55.380 New DB connection, total: 1<br>2006-10-16 22:50:03.430 Unable to connect to database!<br>2006-10-16 22:50:03.430 Driver error was [1/1045]:<br>QMYSQL3: Unable to connect<br>Database error was:<br>
Access denied for user 'mythtv'@'<a href="http://192.168.0.6">192.168.0.6</a>' (using password: YES)<br><br>2006-10-16 22:50:11.526 DB Error (KickDatabase):<br>Query was:<br>SELECT NULL;<br>No error type from QSqlError? Strange...
<br>2006-10-16 22:50:19.615 Unable to connect to database!<br>2006-10-16 22:50:19.615 Driver error was [1/1045]:<br>QMYSQL3: Unable to connect<br>Database error was:<br>Access denied for user 'mythtv'@'<a href="http://192.168.0.6">
192.168.0.6</a>' (using password: YES)</blockquote><div><br><br>Have tried the following from <a href="http://www.mythtv.org/docs/mythtv-HOWTO-6.html">http://www.mythtv.org/docs/mythtv-HOWTO-6.html</a><br></div><br></div>
<br><blockquote><h3> Modifying access to the MySQL database for multiple systems </h3><p>If you're going to have multiple systems accessing a master database,
you must grant access to the database from remote systems. By default, the
<code>mc.sql</code> script is only granting access to the local host.</p><p>To allow other hosts access to your master database, you can either set it
up for no security at all, or with more granularity. Note that the "%" is
the wildcard character in MySQL.</p><p>
<img src="http://www.mythtv.org/docs/stop.png">
<b>NOTE</b>: The "no security" option is <em>very</em> dangerous unless
you're in a controlled environment.
This example has no security at all, and allows access from any host.
</p><blockquote><code>
</code><pre>$ mysql -u root mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>mysql> flush privileges;<br></pre>
</blockquote><p>For a more secure setup, you can restrict which machines or subnets have
access. If you have a complete DNS system operational, you could do the
following:
</p><blockquote><code>
</code><pre>$ mysql -u root mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"%.mydomain.com" identified by "mythtv";<br>mysql> flush privileges;<br></pre>
</blockquote><p>Finally, if you just want to restrict by IP subnet (in this example, the
192.168.1. network):
</p></blockquote>
<blockquote><blockquote><code>
</code><pre>$ mysql -u root mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";<br>mysql> flush privileges;<br></pre></blockquote>
</blockquote>