tweak web example sql so it is more portable
Project: http://git-wip-us.apache.org/repos/asf/brooklyn-library/repo Commit: http://git-wip-us.apache.org/repos/asf/brooklyn-library/commit/b67043fa Tree: http://git-wip-us.apache.org/repos/asf/brooklyn-library/tree/b67043fa Diff: http://git-wip-us.apache.org/repos/asf/brooklyn-library/diff/b67043fa Branch: refs/heads/0.6.0 Commit: b67043fa5976690585abc8e7b8ab4f4e739ac193 Parents: 1f31bb0 Author: Alex Heneveld <[email protected]> Authored: Thu Oct 31 19:48:02 2013 -0700 Committer: Alex Heneveld <[email protected]> Committed: Thu Oct 31 19:48:45 2013 -0700 ---------------------------------------------------------------------- .../src/main/resources/visitors-creation-script.sql | 10 ++++++++-- .../camp/src/test/resources/visitors-creation-script.sql | 10 ++++++++-- 2 files changed, 16 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/brooklyn-library/blob/b67043fa/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 f3bdd4a..e1a1de0 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 @@ -1,14 +1,20 @@ create database visitors; use visitors; -create user 'brooklyn' identified by 'br00k11n'; + +# not necessary to create user if we grant (and not supported in some dialects) +# create user 'brooklyn' identified by 'br00k11n'; + grant usage on *.* to 'brooklyn'@'%' identified by 'br00k11n'; + # ''@localhost is sometimes set up, overriding brooklyn@'%', so do a second explicit grant grant usage on *.* to 'brooklyn'@'localhost' identified by 'br00k11n'; + grant all privileges on visitors.* to 'brooklyn'@'%'; + flush privileges; CREATE TABLE MESSAGES ( - id INT NOT NULL AUTO_INCREMENT, + id BIGINT NOT NULL AUTO_INCREMENT, NAME VARCHAR(30) NOT NULL, MESSAGE VARCHAR(400) NOT NULL, PRIMARY KEY (ID) http://git-wip-us.apache.org/repos/asf/brooklyn-library/blob/b67043fa/sandbox/camp/src/test/resources/visitors-creation-script.sql ---------------------------------------------------------------------- diff --git a/sandbox/camp/src/test/resources/visitors-creation-script.sql b/sandbox/camp/src/test/resources/visitors-creation-script.sql index f3bdd4a..e1a1de0 100644 --- a/sandbox/camp/src/test/resources/visitors-creation-script.sql +++ b/sandbox/camp/src/test/resources/visitors-creation-script.sql @@ -1,14 +1,20 @@ create database visitors; use visitors; -create user 'brooklyn' identified by 'br00k11n'; + +# not necessary to create user if we grant (and not supported in some dialects) +# create user 'brooklyn' identified by 'br00k11n'; + grant usage on *.* to 'brooklyn'@'%' identified by 'br00k11n'; + # ''@localhost is sometimes set up, overriding brooklyn@'%', so do a second explicit grant grant usage on *.* to 'brooklyn'@'localhost' identified by 'br00k11n'; + grant all privileges on visitors.* to 'brooklyn'@'%'; + flush privileges; CREATE TABLE MESSAGES ( - id INT NOT NULL AUTO_INCREMENT, + id BIGINT NOT NULL AUTO_INCREMENT, NAME VARCHAR(30) NOT NULL, MESSAGE VARCHAR(400) NOT NULL, PRIMARY KEY (ID)
