[mythtv-users] Stumped: MySQL and accessing the BE from a separate FE

[Nick Morrott]

On 20/08/2009, leifontheroad <leifontheroad at hotmail.com> wrote:
>
>
> > How are you granting permissions? Are you using the GRANT command?
> > (http://dev.mysql.com/doc/refman/5.1/en/grant.html)
>
> > Make sure you FLUSH PRIVILEGES after GRANTing them...
>
> I'm doing a copy paste from the Mythtv docs at
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2.
> Here's exactly what I did:
>
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> mysql> flush privileges;

Try using single quotes instead of double quotes when quoting the
username, host and password:

mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by 'mythtv';