first creating username
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
then define the permissions on what ?
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';