Skip to content

Instantly share code, notes, and snippets.

@firefirer1983

firefirer1983/MYSQL数据导入导出.md

Last active January 15, 2021 09:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save firefirer1983/15867cea46e886b7b84edcb9d04c5cc8 to your computer and use it in GitHub Desktop.
Save firefirer1983/15867cea46e886b7b84edcb9d04c5cc8 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL命令
Raw
MYSQL数据导入导出.md

MYSQL命令

MYSQL增添用户 增添权限

CREATE USER 'xy'@'%' IDENTIFIED BY '123456';
GRANT ALL ON sfa.* TO 'xy'@'%';

MYSQL 数据导入导出

sudo apt-get install mysql-client
mysqldump -uroot -h127.0.0.1 -p --no-create-info sfa fundingrate > /home/xy/fundingrate.sql
scp xy@http://8.210.182.199:/home/xy/fundingrate.sql .
mysqlimport -uroot -h127.0.0.1 -p --local sfa fundingrate.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment