From 7c9410246fc64f2638de7779b11070d95e7756e3 Mon Sep 17 00:00:00 2001
From: Loic Guegan <manzerberdes@gmx.com>
Date: Fri, 17 May 2019 11:08:57 +0200
Subject: Add analysis script

---
 g5k_bak/setup-mysql.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 g5k_bak/setup-mysql.sql

(limited to 'g5k_bak/setup-mysql.sql')

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'@'%';
+
-- 
cgit v1.2.3

