MySQL - Basic User Administration

The most basic type is:

mysql> CREATE USER 'luna'@'localhost';

Query OK, 0 rows affected (0.03 sec)

When password is needed, type:

mysql> CREATE USER 'luna'@'localhost' IDENTIFIED BY 'password';

Query OK, 0 rows affected (0.00 sec)

To remove a user, type:

mysql> DROP USER 'luna'@'localhost';

Query OK, 0 rows affected (0.00 sec)

MySQL - Basic User Administration