[mythtv-users] mySQL privileges question

[Craig Huff]

Thanks, I'll try that.  In the meantime, I found a method to check access
from a client FE by logging in there and trying to remotely access mysql on
the command line.  That worked, so I started researching the "SHOW GRANTS"
syntax.  It implied that I could only see the grants for the user I logged
in as, and indeed, I got different answers when I entered the mysql command
"SHOW GRANTS;" while I was logged in from the remote FE.

In summary, I got these two sets of results, based on where I logged in
from:

+-----------------------------------------------------------------------------------------------------------------------------+
| Grants for mythtv at localhost
                                      |
+-----------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY PASSWORD
<secret> |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'localhost'
              |
+-----------------------------------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------------------------------------------------+
| Grants for mythtv@%
                              |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY PASSWORD <secret> |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%'
       |
+-------------------------------------------------------------------------------------------------------------------+

So, I appear to be in good shape and don't need to do anything.

Thanks for the response!

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