CREATE USER 'username' IDENTIFIED BY 'password';

CREATE USER 'username'@'ip_address' IDENTIFIED BY 'password';

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT permission_type ON database.table TO 'username'@'localhost';

SHOW GRANTS username;