创建用户:
grant all on *.* to [email protected]‘%‘ identified by ‘ma1‘ with grant option;
grant all on *.* to [email protected]‘%‘ identified by ‘ma2‘ with grant option;
grant all on *.* to [email protected]‘%‘ identified by ‘ma3‘ with grant option;
flush privileges;
select user,host,password from mysql.user;
创建与atb表结构相同的5张表:
use test
create table btb(id int,name varchar(50));
create table btb_trace(name varchar(50),time varchar(50),act varchar(20),id varchar(20),sname varchar(50));
create table btb_bak(user varchar(100),id int,name varchar(50),del_time varchar(50));
create table btb_del(user varchar(100),id int,name varchar(50),del_time varchar(50));
create table btb_update(user varchar(100),id int,name varchar(50),del_time varchar(50));
inser