· 5 years ago · May 21, 2020, 03:46 PM
1drop user if exists 'vulnUser'@'localhost';
2create user 'vulnUser'@'localhost' IDENTIFIED BY 'vulnPassword';
3create database if not exists vulnSensors;
4grant all privileges on vulnSensors.* TO 'vulnUser'@'localhost';
5use vulnSensors;
6drop table if exists sensors;
7create table sensors(no int not null auto_increment, timestmp varchar(100), device varchar(100),value varchar(100) , primary key (no));
8create table devices(id int not null auto_increment, device varchar(100), status varchar(100), primary key(id));