mysql 远程导出文件命令行

mysqldump -h 远程服务器IP -u 用户名 -p密码 数据库名 > 导出文件路径.sql

mysqldump -h 192.168.1.100 -u root -p123456 mydatabase > /home/user/exported_data.sql

mysql -h 远程服务器IP -u 用户名 -p密码 -e "SELECT * INTO OUTFILE '/path/to/remote/file.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM 数据库表名" 数据库名

mysql -h 192.168.1.100 -u root -p123456 -e "SELECT * INTO OUTFILE '/tmp/mytable.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM mydatabase.mytable" mydatabase

# bind-address = 127.0.0.1

GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON mydatabase.* TO '用户名'@'远程服务器IP';
FLUSH PRIVILEGES;

GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER ON mydatabase.* TO 'root'@'192.168.1.100';
FLUSH PRIVILEGES;