mysql_usercreate []

This is an old revision of the document!

CREATE USER 'luke'@'x.x.x.x' IDENTIFIED BY 'testpassword';

Use % for wildcard host. Accessible from any locations. E.g

CREATE USER 'luke'@'%' IDENTIFIED BY 'testpassword';

SET PASSWORD FOR 'root'@'localhost'

drop user 'luke'@'x.x.x.x';