<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div style="font-family:Calibri, Arial, Helvetica, sans-serif; font-size:12.0pt; line-height:1.3; color:#1F497D" id="nine_body_n17ca58-378cd" class="nine_body" dir="auto">
<div class="nine-pg" dir="auto"> </div>
</div>
<div id="quoted_body_n17ca58-378cd" class="quoted_body_editor mceEditable" dir="auto">
<blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="nine-pg" dir="auto">
<div class="nine-pg" dir="auto">>>> While on the server, I have:</div>
<div class="nine-pg" dir="auto">>>> </div>
<div class="nine-pg" dir="auto">>>> select * from mysql.user \G</div>
<div class="nine-pg" dir="auto">>>> </div>
<div class="nine-pg" dir="auto">>>> gives:</div>
<div class="nine-pg" dir="auto">>>> </div>
<div class="nine-pg" dir="auto">>>> *************************** 5. row ***************************</div>
<div class="nine-pg" dir="auto">>>> Host: %</div>
<div class="nine-pg" dir="auto">>>> User: mythtv</div>
<div class="nine-pg" dir="auto">>>> etc.</div>
<div class="nine-pg" dir="auto">>>> </div>
<div class="nine-pg" dir="auto">>>> so as near as I can see, user mythtv has the privilege to access.</div>
<div class="nine-pg" dir="auto">>>> Can someone explain what I am doing wrong?</div>
<div class="nine-pg" dir="auto">>></div>
<div class="nine-pg" dir="auto"><br data-mce-bogus="1">
</div>
</div>
</blockquote>
<div class="nine-pg" dir="auto">
<div class="nine-pg" dir="auto">A while ago (multiple years) I had issues with straight '%' working as wildcard. I started using something like '192.168.1.%' instead and have had no issues since so I never bothered looking further. Try adding a more precise
host descriptor to the database?</div>
</div>
</div>
</body>
</html>