修改密码
update user set password=PASSWORD(‘123456‘) where User=‘root‘;
添加用户设置权限
grant select,insert,update,delete on *.* to test1@"%" Identified by "test";
grant all privileges on *.* to test@"%" Identified by "test";
原文：http://www.cnblogs.com/fuyuanming/p/5060597.html