<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"><title>Re: [mythtv-users] Stumped: MySQL and accessing the BE from a separate FE</title>
</head>
<body>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt"><br>
On 8/20/09 11:49 AM, "leifontheroad" <<a href="leifontheroad@hotmail.com">leifontheroad@hotmail.com</a>> wrote:<br>
<br>
</span></font><blockquote><span style="font-size:11pt"><font face="Verdana, Helvetica, Arial">> How are you granting permissions? Are you using the GRANT command? <br>
> (<a href="http://dev.mysql.com/doc/refman/5.1/en/grant.html">http://dev.mysql.com/doc/refman/5.1/en/grant.html</a></font><font face="Calibri, Verdana, Helvetica, Arial"> <<a href="http://dev.mysql.com/doc/refman/5.1/en/grant.html">http://dev.mysql.com/doc/refman/5.1/en/grant.html</a>> </font><font face="Verdana, Helvetica, Arial">) <br>
<br>
> Make sure you FLUSH PRIVILEGES after GRANTing them... <br>
</font><font face="Calibri, Verdana, Helvetica, Arial"> <br>
</font><font face="Verdana, Helvetica, Arial">I'm doing a copy paste from the Mythtv docs at <a href="http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2">http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2</a>. Here's exactly what I did:<br>
</font><font face="Calibri, Verdana, Helvetica, Arial"> <br>
$ mysql -u root mythconverg<br>
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>
mysql> flush privileges;<br>
<br>
</font></span></blockquote><span style="font-size:11pt"><font face="Calibri, Verdana, Helvetica, Arial">This is just a stab in the dark, but have you tried specifying the database name on the command line? I have had issues in the past with mysql users that don’t have any global MySQL rights connecting to the “root” of the database server. Try:<br>
<br>
</font><font face="Arial">mysql -u mythtv -p -h 192.168.5.19 mythconverg<br>
</font><font face="Calibri, Verdana, Helvetica, Arial"><br>
If this works, I still have no idea why Myth doesn’t want to connect. I am assuming that you are either using default ports or have them properly specified in the MythTV setup?</font></span>
</body>
</html>