Revision: 462
http://svn.savannah.gnu.org/viewvc/?view=rev&root=administration&revision=462
Author: rwp
Date: 2022-03-23 17:41:23 -0400 (Wed, 23 Mar 2022)
Log Message:
-----------
Update MySQL example syntax
Modified Paths:
--------------
trunk/sviki/SavannahHosts.mdwn
Modified: trunk/sviki/SavannahHosts.mdwn
===================================================================
--- trunk/sviki/SavannahHosts.mdwn 2022-01-25 07:42:00 UTC (rev 461)
+++ trunk/sviki/SavannahHosts.mdwn 2022-03-23 21:41:23 UTC (rev 462)
@@ -534,10 +534,10 @@
CREATE DATABASE savane CHARACTER SET utf8;
GRANT ALL ON savane.* TO root@localhost;
GRANT ALL ON savane.* TO savannahscripts@$WEBIP IDENTIFIED BY '******';
- GRANT SELECT, SHOW VIEW ON savane.* TO nss-user@$VCSIP IDENTIFIED BY
'******';
- GRANT SELECT, SHOW VIEW ON savane.* TO nss-user@$DOWNLOADIP IDENTIFIED BY
'******';
- GRANT ALL ON savane.* TO nss-root@$VCSIP IDENTIFIED BY '******';
- GRANT ALL ON savane.* TO nss-root@$DOWNLOADIP IDENTIFIED BY '******';
+ GRANT SELECT, SHOW VIEW ON savane.* TO 'nss-user'@'$VCSIP' IDENTIFIED BY
'******';
+ GRANT SELECT, SHOW VIEW ON savane.* TO 'nss-user'@'$DOWNLOADIP' IDENTIFIED
BY '******';
+ GRANT ALL ON savane.* TO 'nss-root'@'$VCSIP' IDENTIFIED BY '******';
+ GRANT ALL ON savane.* TO 'nss-root'@'$DOWNLOADIP' IDENTIFIED BY '******';
FLUSH PRIVILEGES;
Create a read-only user `savane_ro`
