init/createdatabase.sql

USE app;

CREATE TABLE users(
    user_id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(255),
    password VARCHAR(255),
    
);

INSERT INTO users(username,password) VALUES('sample','sample');
INSERT INTO users(username,password) VALUES('test','test');
INSERT INTO users(username,password) VALUES('app','app');

GRANT ALL ON app.* TO test;