En trois lignes :

CREATE USER 'monutilisateur'@'localhost' IDENTIFIED BY 'monmotdepasse';

GRANT ALL PRIVILEGES ON *.* TO 'monutilisateur'@'locahost' WITH GRANT OPTION;

FLUSH PRIVILEGES;