<div dir="ltr">On Sun, Apr 28, 2013 at 6:16 AM, Paul Gardiner <span dir="ltr"><<a href="mailto:lists@glidos.net" target="_blank">lists@glidos.net</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><span style="color:rgb(34,34,34)">GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;</span></div>
</blockquote><div><br></div><div>I get a syntax error on that step:</div><div><div>mysql> GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;</div><div>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mythtv' at line 1</div>
</div><div><br></div><div>If I leave off the "IDENTIFIED BY" bit:</div><div>GRANT ALL ON mythconverg.* TO mythtv@"%";<br></div><div><br></div><div>I don't get an error, but I imagine that bit's important... But I know nothing about mysql so have no idea what I'm doing.</div>
<div><br></div><div style>Just tried</div><div style> GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY 'mythtv';<br></div><div style>(single quotes on 'mythtv' at the end) and it worked. Is that correct?</div>
<div style><br></div><div style><br></div></div></div></div>