想弄清除逻辑备份的原理,最好的办法是开启general_log,一探究竟
准备创建用户
CREATE USER IF NOT EXISTS 'test1'@'%' IDENTIFIED WITH mysql_native_password BY 'test1'; grant create,index,reload,insert,select,update,delete,alter,drop on *.* to 'test1'@'%'; grant reload,select,replication client,view,event on *.* to 'test1'@'%'; CREAT