[mythtv-users] Fixing minor errors in Myth database
Paul Gardiner
lists at glidos.net
Sun Apr 28 16:46:20 UTC 2013
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.
More information about the mythtv-users
mailing list