[mythtv-users] mySQL privileges question

[Craig Huff]

Waaaaaaaay back in the dark ages (setting up my first MythTV system with
Jarrod Wilson's HOWTO on FC6!!) privileges were granted to the mythconverg
DB using a command like:


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

IIRC, this was to ensure that slave FEs could get info out of the database
over the network.

Since I'm upgrading my router/firewall and changing the subnet from
192.168.53.xx to a more standard one, I wanted to find out if this was
still a necessity.  I checked on my FE/BE/mySQL server with:

mysql> SHOW GRANTS;

and got (along with other grants) this:

GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'localhost'

Since my FEs are working just fine, I'm wondering if the old GRANT line is
no longer necessary, or if I didn't query the database with the right
question?

Can someone set me on the right path here?

--
Craig.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20161209/b07b4e31/attachment.html>