创建用户分配权限
CREATE USER ‘bill‘@‘%‘ IDENTIFIED BY ‘passpass‘;
grant all privileges on *.* to bill@localhost identified by ‘passpass‘ with grant option;Access denied for user 'bill'@'localhost' (using password: YES)
原文：http://blog.csdn.net/hackcoder/article/details/42172189