<div class="gmail_quote">On Tue, May 18, 2010 at 7:00 AM, Mike Perkins <span dir="ltr"><<a href="mailto:mikep@randomtraveller.org.uk">mikep@randomtraveller.org.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div><div></div>Note that 0.0.0.0 translates to <a href="http://0.0.0.0/32" target="_blank">0.0.0.0/32</a>, ie a single address. To make sure, you should specify <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> to ensure you cover the whole address space (which I assume is what you want).<br>
</div>
<br>
Some software assumes 0.0.0.0 without subnet bits is everything, some doesn't. Best way is to be explicit.<br></blockquote><div><br>As far as I can tell, "bind-address=<a href="http://0.0.0.0/0">0.0.0.0/0</a>" is not allowed. Any attempt to start the server hangs for me if I put that in there. Changing it back to "bind-address=0.0.0.0" doesn't have the same problem.<br>
<br>Besides, I don't think that is the issue. The connection is not refused, access is simply being denied.<br><br>Is there some way to get MySQL to spit out some kind of explanation in the log files? The only thing I could find was an option to log queries and/or slow queries. What I want is a log entry that says something like "User mythtv attempted to login from host ___, access from that host is not allowed" or something. I can't figure out whether this is an issue with the host pattern somehow or whether there is something going on where it is doing a reverse name lookup or something that confuses the issue. I figured by using IP I'd be safe but I'm not 100% sure.<br>
<br>--<br>Mike<br><br></div></div>