src/g5k/setup-mysql.sql


1
2
3
4
5
6
7
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'@'%';