1. 备份
mysqldump -h ip -u -p DBNAME>bck.sql
2. 允许远程连接
例如,允许所有机器使用root用户登录
use mysql;
select Host,User from user;
update user set Host='%' where User='root';
flush privileges;
mysqldump -h ip -u -p DBNAME>bck.sql
例如,允许所有机器使用root用户登录
use mysql;
select Host,User from user;
update user set Host='%' where User='root';
flush privileges;