mysql create user

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

GRANT ALL ON db1.* TO 'jeffrey'@'localhost';

flush privileges;