[Hyperic-hq-discuss] hq r14536 - trunk/plugins/mysql_stats/etc

[<sc...@hy...>]

Author: scottmf
Date: 2010-04-22 10:39:44 -0700 (Thu, 22 Apr 2010)
New Revision: 14536
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=14536

Modified:
   trunk/plugins/mysql_stats/etc/hq-plugin.xml
Log:
[HHQ-3881] updated plugin docs to show an example of a user that is able to monitor mysql with a non-root privileges

Modified: trunk/plugins/mysql_stats/etc/hq-plugin.xml
===================================================================
--- trunk/plugins/mysql_stats/etc/hq-plugin.xml	2010-04-22 07:53:31 UTC (rev 14535)
+++ trunk/plugins/mysql_stats/etc/hq-plugin.xml	2010-04-22 17:39:44 UTC (rev 14536)
@@ -2113,10 +2113,18 @@
   monitoring are:
   </p>
   <ul>
-    <li>The configured mysql has the ability to connect to the MySQL server specified by the ${jdbcUrl}</li>
-    <li>The user ${jdbcUser} is able to execute the following statements:
-        'SHOW GLOBAL STATUS', 'SHOW SLAVE STATUS' (minimal privileges needed:
-        SELECT, REPLICATION CLIENT)</li>
+    <li>The configured mysql must have the ability to connect to the MySQL server specified by the ${jdbcUrl}</li>
+    <li>
+        The user ${jdbcUser} is able to execute the following statements:
+        'SHOW GLOBAL STATUS', 'SHOW SLAVE STATUS', 'SHOW DATABASES'
+        (minimal privileges needed: SELECT, REPLICATION CLIENT)
+        <ul>
+        Examples: <br>
+        mysql> create user 'hqagent'@'localhost' identified by 'hqagent'; <br>
+        mysql> grant show databases on *.* to 'hqagent'@'localhost'; <br>
+        mysql> grant select on *.* to 'hqagent'@'localhost'; <br>
+        </ul>
+    </li>
     <li>To enable full process monitoring of the MySQL daemon the agent user must either own the process or have permissions to view all process stats.</li>
   </ul>
   <p>Shared properties (values propagate to child services):</p>