Créer un utilisateur et sa base avec mysql

CREATE DATABASE mabase;
USE mysql;
DROP user 'user'@'localhost';
FLUSH PRIVILEGES;
CREATE USER 'user'@'localhost' IDENTIFIED BY 'mot_de_passe';
GRANT ALL PRIVILEGES ON mabase.* TO 'user'@'localhost';
FLUSH PRIVILEGES;

ALTER USER 'user'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';
FLUSH PRIVILEGES;