mysql> CREATE USER 'myname'@'%.mydomain.com' IDENTIFIED BY 'mypass';