mysql dump -u root -p juhui > /data/juhui.sql //备份数据库
grant all privileges on *.* to xf111 identified by 'xf11111'; //授权用户登陆
update user set host='%' where user='xf111';
flush privileges; //加入注册
exit; //退出
本文共 256 字，大约阅读时间需要 1 分钟。
mysql dump -u root -p juhui > /data/juhui.sql //备份数据库
grant all privileges on *.* to xf111 identified by 'xf11111'; //授权用户登陆
update user set host='%' where user='xf111';
flush privileges; //加入注册
exit; //退出
转载于:https://www.cnblogs.com/xiamibk/p/4521215.html