LINUX数据库的备份,以及远程授权登陆

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; //退出

原文地址:https://www.cnblogs.com/xiamibk/p/4521215.html