=== Mysql User Creation ===

<sxh bash>CREATE USER 'luke'@'x.x.x.x' IDENTIFIED BY 'testpassword';</sxh>
Use % for wildcard host. Accessible from any locations. E.g
<sxh bash>CREATE USER 'luke'@'%' IDENTIFIED BY 'testpassword';</sxh>
\\
=== Setting user password ===

<sxh bash>SET PASSWORD FOR 'root'@'localhost'</sxh>
\\
=== Deleting a user ===

<sxh bash>drop user 'luke'@'x.x.x.x';</sxh>

\\
\\

=== Checking MySQL Password ===
Sometimes you forget the password for a user. 
This is annoying as hell. You have a list of old passwords but you are able to log in as root
You can use the following to confirm if the password is correct:

<sxh bash>
mysql> select if(password('randompassword')=password, 'YES', 'NO') from mysql.user where user='lukeslinux';
+-----------------------------------------------------+
| if(password('randompassword')=password, 'YES', 'NO') |
+-----------------------------------------------------+
| YES                                                 |
+-----------------------------------------------------+
1 row in set (0.00 sec)
</sxh>