[mythtv-users] mySQL privileges question
Craig Huff
huffcslists at gmail.com
Fri Dec 9 18:46:33 UTC 2016
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>
More information about the mythtv-users
mailing list