This article explains some basic commands for mysql user management.

Add mysql user

Login to mysql as root

$ mysql -uroot -p

>