CREATE USER 'user'@'localhost' IDENTIFIED BY 'new_password';

DROP USER 'user'@'localhost';

Se connecter au préalable.

CREATE DATABASE nom_base;

DROP DATABASE nom_base;

SHOW DATABASES;

GRANT ALL ON *.* TO 'user'@'localhost';

GRANT ALL ON nom_base.* TO 'user'@'localhost';

SHOW GRANTS FOR 'root'@'localhost';

mysql -u user -p