Revision: 241
http://svn.sv.gnu.org/viewvc/?view=rev&root=administration&revision=241
Author: agn
Date: 2016-09-29 00:08:12 +0000 (Thu, 29 Sep 2016)
Log Message:
-----------
SavannahHosts: mention read-only MySQL user on internal0
Modified Paths:
--------------
trunk/sviki/SavannahHosts.mdwn
Modified: trunk/sviki/SavannahHosts.mdwn
===================================================================
--- trunk/sviki/SavannahHosts.mdwn 2016-09-27 00:14:58 UTC (rev 240)
+++ trunk/sviki/SavannahHosts.mdwn 2016-09-29 00:08:12 UTC (rev 241)
@@ -471,6 +471,12 @@
GRANT ALL ON savane.* TO root@localhost;
FLUSH PRIVILEGES;
+Create a read-only user `savane_ro`
+to enable safer troubleshooting of database issues
+(see `internal0:/root/agn/create-savane-readonly-user.sh` for full details)
+
+ GRANT SELECT, SHOW VIEW ON savane.* TO [email protected]
IDENTIFIED BY '******';
+
Set up munin-node. (libcache-cache-perl is needed for the extra mysql
plugin.) Then install the extra mysql plugin with all of the
suggested interfaces.
