[Savannah-cvs] [241] SavannahHosts: mention read-only MySQL user on internal0

[assafgordon]

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 address@hidden;
     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 address@hidden 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.