weixin_43714335的博客

MySQLdump增量备份配置执行增量备份的前提条件是MySQL打开binlog日志功能，在my.cnf中[mysqld]加入#log-bin=mysql-bin#server-id=1然后重启mysql。Innodb 的mysqldump全量备份 + mysqlbinlog二进制日志增量备份mysqldump命令必须带上–flush-logs选项以生成新的二进制日志文件：#...

1.创建用户CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';CREATE USER ‘用户名’@‘限制的IP地址’ IDENTIFIED BY ‘密码’;2.授权GRANT SELECT, INSERT ON test.user TO 'pig'@'%';#GRANT ALL ON *.* TO 'pig'@'%';FLUS...