To create MySQL user you should have root access for SSH. First of all you have to login to MySQL server through command line.
-----
# mysql -u root -p ******
-----
Here, -u option is for username and -p option is for password.
Now, you will be at MySQL prompt and it looks like this :
-----
#...