如何在运行对话框里运行mysql的备份命令
我在开始菜单的运行对话框里输入mysqldump --user=root --password=123456 stu>E:\114.dmp
结果并没有生成备份文件114.dmp
我必须先在运行对话框里输入cmd,弹出cmd的界面,然后输入mysqldump --user=root --password=123456 stu>E:\114.dmp
这样才能生成备份文件114.dmp
grant select on *.* to 'bbsdiscuz'@'%' identified by 'bbsanddepot' with grant option;
mysql>;GRANT FILE ON *.* TO backup@192.168.1.200 IDENTIFIED BY ‘1234’;
mysql>;\exit
开放一个账号backup密码1234给来自IP:192.168.1.200有档案处理的权限
格式:grant 权限 on 数据库名.表名 用户@登录主机 identified by "用户密码";
mysql>;grant select,update,insert,delete on *.* to atyu30@10.0.0.100 identified by "1234";
mysql>;grant all on *.* to atyu30@10.0.0.100 identified by "1234";
评论