[mythtv-users] Fixing minor errors in Myth database

[Paul Gardiner]

On 28/04/2013 17:34, Fred Hamilton wrote:
> On Sun, Apr 28, 2013 at 6:16 AM, Paul Gardiner <lists at glidos.net
> <mailto:lists at glidos.net>> wrote:
>
>        DROP DATABASE mythconverg;
>        CREATE DATABASE mythconverg;
>        GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;
>        FLUSH PRIVILEGES;
>        QUIT;
>
> Thanks Paul!  Do I need to worry about MySQL passwords/permissions?

The line

     GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;

gives access to the mythtv database with username mythtv and password
mythtv. You could use a different password. You could change the % to
something like "192.168.0.%" to restrict access to just your local
network.  Realistically, you are probably protected from the internet
by a router with a firewall, so you shouldn't need to worry, unless
you think you might have a malicious person or program on your
home network.

Paul.