mysql常用命令汇总

使用mysqldump:备份mysqldump -u databasename -p -h localhost databasename>d:demo.sql还原mysql -h localhost -u root -p123456 databasename<d:demo.sql
开启mysql的root用户远程访问权限：use mysql;
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES;