//登录MYSQL
mysql -u root -p
//创建用户
insert into mysql.user(Host,User,Password) values(‘localhost’,‘jeecn’,password(‘jeecn’));
//刷新系统权限表
flush privileges;
grant select,insert,update,delete,create,drop on zhengxin.*to dataadmin@127.0.0.1 identified by ‘123456′;
原文：http://www.cnblogs.com/fangyuan303687320/p/5329008.html