mysql dump -u root -p juhui > /data/juhui.sql //备份数据库
grant all privileges on *.* to xf111@localhost identified by ‘xf11111‘; //授权用户登陆
update user set host=‘%‘ where user=‘xf111‘;
flush privileges; //加入注册
exit; //退出
原文：http://www.cnblogs.com/xiamibk/p/4521215.html