CREATE DATABASE IF NOT EXISTS remote;
GRANT ALL PRIVILEGES ON remote.* TO 'myuser'@'%' IDENTIFIED BY 'remote';
GRANT ALL PRIVILEGES ON remote.* TO 'myuser'@'localhost' IDENTIFIED BY 'remote';

DROP TABLE IF EXISTS USER;
CREATE TABLE USER (
  lastname varchar(255) NOT NULL,
  firstname varchar(255) NOT NULL,
  email varchar(255) NOT NULL,
  password varchar(255) NOT NULL,
  random varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO USER VALUES (
  'John', 'locke', 'j.locke@mse.cadoles.com', '$2y$10$f8SevJVlAx8pnjrIK5OGruKGJdC95avev8CueEH8i8WcYb32r1H9m', 'phrase random'
),(
  'md', 'cinq', 'md5@cadoles.com', '098f6bcd4621d373cade4e832627b4f6', 'un truc'
),(
  'sha', 'one',  'shaone@cadoles.com', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', 'un autre truc'
);