createuser 'serveruser'@'%' identified by 'bitc5600';
GRANT ALL PRIVILEGES ON*.* TO 'serveruser'@'%';
createdatabaseserveruser;
serveruser
use serveruser;
createtableusers;
CREATETABLEuser(
id intprimary key auto_increment,
username varchar(100) not null unique,
password varchar(100) not null,
email varchar(100) not null,
role varchar(20)
) engine=InnoDB default charset=utf8;
insert into user(username,password,email,role) values('ssar','1234','ssar@nate.com','user');
commit;