Create user

create_user.sql

// Show users
select * from mysql.user;
select host, user, password from mysql.user;

// Create user
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

// Grant privileges
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
GRANT LOCK TABLES, ALTER, INSERT, SELECT, UPDATE, CREATE TEMPORARY TABLES, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE  ON db_.* TO 'newuser'@'localhost';

FLUSH PRIVILEGES;