Create a user in MySql

This is how to create a SQL user programmatically; 

it also gives the user the visibility from local machine and external machines.

CREATE USER 'username'@'localhost' IDENTIFIED BY 'my_password';
CREATE USER 'username'@'%' IDENTIFIED BY 'my_password';