[mythtv-users] My MySql hell :-)

[Nick Morrott]

On 09/03/07, Peter Abplanalp <pta-myth at psaconsultants.com> wrote:
>
> ----- Original Message -----
> From: "Damian Surr" <damian at gingermagic.co.uk>
> To: "Discussion about mythtv" <mythtv-users at mythtv.org>
> Sent: Friday, March 9, 2007 12:59:47 PM (GMT-0700) America/Denver
> Subject: [mythtv-users] My MySql hell :-)
>
>
> > GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'192.168.0.102' IDENTIFIED BY
> 'some_pass' WITH GRANT OPTION;
> > flush privileges;
>
> ack!  you want to limit the change to the mythconverg db, so the command
> becomes:
>
> GRANT ALL PRIVILEGES ON mythconverg.* TO 'mythtv'@'192.168.0.102' IDENTIFIED
> BY 'some_pass' WITH GRANT OPTION;
> flush privileges;

You might want to consider granting privileges to all mythtv users on
your local 192.168.0/24 subnet in case you either add more machines,
or your mythtv machine changes its IP address:

mysql> grant all on mythconverg.* to mythtv@"192.168.0.%" identified by "$PASS";

Once you are confident as to what you are doing, you can revert back
to granting privileges per IP and/or using separate passwords for each
machine.

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin