summaryrefslogtreecommitdiff
path: root/g5k_bak/setup-mysql.sql
diff options
context:
space:
mode:
authorLoic Guegan <manzerberdes@gmx.com>2019-05-17 11:08:57 +0200
committerLoic Guegan <manzerberdes@gmx.com>2019-05-17 11:08:57 +0200
commit7c9410246fc64f2638de7779b11070d95e7756e3 (patch)
tree2cd99dbd0241bcf3209b3bf09b2f27ad64cc6af6 /g5k_bak/setup-mysql.sql
parent1ab4a6a97aab850aa496fccc8c26293c57561620 (diff)
Add analysis script
Diffstat (limited to 'g5k_bak/setup-mysql.sql')
-rw-r--r--g5k_bak/setup-mysql.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/g5k_bak/setup-mysql.sql b/g5k_bak/setup-mysql.sql
new file mode 100644
index 0000000..05042a3
--- /dev/null
+++ b/g5k_bak/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'@'%';
+