Repository: brooklyn-library Updated Branches: refs/heads/master 798ef11d9 -> 64f5ccddd
Update visitors-creation-script.sql Project: http://git-wip-us.apache.org/repos/asf/brooklyn-library/repo Commit: http://git-wip-us.apache.org/repos/asf/brooklyn-library/commit/85bc874a Tree: http://git-wip-us.apache.org/repos/asf/brooklyn-library/tree/85bc874a Diff: http://git-wip-us.apache.org/repos/asf/brooklyn-library/diff/85bc874a Branch: refs/heads/master Commit: 85bc874af011ff6e9de2045c24ccf323d398cb8a Parents: 798ef11 Author: Graeme-Miller <[email protected]> Authored: Thu Sep 14 16:16:53 2017 +0100 Committer: GitHub <[email protected]> Committed: Thu Sep 14 16:16:53 2017 +0100 ---------------------------------------------------------------------- .../src/main/resources/visitors-creation-script.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/brooklyn-library/blob/85bc874a/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql ---------------------------------------------------------------------- diff --git a/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql b/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql index 1640d1b..2fef262 100644 --- a/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql +++ b/examples/simple-web-cluster/src/main/resources/visitors-creation-script.sql @@ -20,13 +20,12 @@ create database visitors; use visitors; -# the below will create user (and note create user not supported in some dialects) +# Create two users: 'brooklyn'@'%' and 'brooklyn'@'localhost' with full access # default password specified for compatibility with older blueprints that don't provide config; # if your blueprint sets the password it can be removed here grant usage on *.* to 'brooklyn'@'%' identified by '${config["creation.script.password"]!"br00k11n"}'; -grant all privileges on visitors.* to 'brooklyn'@'%'; # useful if sockets work also -grant all privileges on visitors.* to 'brooklyn'@'localhost'; +grant all privileges on *.* to 'brooklyn'@'localhost' identified by '${config["creation.script.password"]!"br00k11n"}'; # drop the anonymous users eg ''@'localhost' and sometimes other local hostnames # (necessary for same-host access as these are more restrictive rules that trump the wildcard above)
