SQL create user and grant permission

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

GRANT SELECT ON mydbschema.* TO 'someuser'@'localhost';