1. create user
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
Here Identified by is actually by password. So just type in the password
CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';
Also, can create user by a very simple sentence
CREATE USER username;
This kind of user could access the MySQL database from any available computer without password.
2. give user privilege
grant all privileges on DBNAME.* to USERNAME@HOST identified by 'PASSWORD';
To give privileges to user that has no specific host (usually 'anyhost' or '%'), just don't add the '@HOST'
remember to refresh privilege list
flush privileges
3. you can check the user and privileges in the table mysql.user
select * from mysql.user
references:
http://blog.csdn.net/leili0806/article/details/8573636
http://www.cnblogs.com/analyzer/articles/1045072.html