From 5720cf71f4ecb5a54719f6957d5ad817bc4c2317 Mon Sep 17 00:00:00 2001
From: Loic Guegan <manzerberdes@gmx.com>
Date: Fri, 19 Apr 2019 16:46:19 +0200
Subject: Add G5K scripts

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

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

diff --git a/g5k/setup-mysql.sql b/g5k/setup-mysql.sql
new file mode 100644
index 0000000..05042a3
--- /dev/null
+++ b/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'@'%';
+
-- 
cgit v1.2.3

