summaryrefslogtreecommitdiff
path: root/src/g5k/setup-mysql.sql
diff options
context:
space:
mode:
authorLoic Guegan <manzerberdes@gmx.com>2019-05-22 11:24:17 +0200
committerLoic Guegan <manzerberdes@gmx.com>2019-05-22 11:24:17 +0200
commit8bdcd37ac44fe96d2c59424a24752f87f0444e36 (patch)
treee31a0fe38c01bc6814a0b35474875fe538ea87c2 /src/g5k/setup-mysql.sql
parent5a77b67d6baae0414310d29cab6f240963866062 (diff)
Update paper
Diffstat (limited to 'src/g5k/setup-mysql.sql')
-rw-r--r--src/g5k/setup-mysql.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/g5k/setup-mysql.sql b/src/g5k/setup-mysql.sql
new file mode 100644
index 0000000..05042a3
--- /dev/null
+++ b/src/g5k/setup-mysql.sql
@@ -0,0 +1,8 @@
+create DATABASE IF NOT EXISTS experiment;
+use experiment;
+create TABLE IF NOT EXISTS temperature (id INTEGER,stamp INTEGER, val INTEGER);
+
+use mysql;
+CREATE USER 'user'@'%' IDENTIFIED BY 'mysql';
+GRANT ALL ON experiment.* TO 'user'@'%';
+