MySQL create users and grant privilege

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