创建一个用户,并授予其数据库所有权限
CREATE USER admin@'%' IDENTIFIED BY '123456';
grant all privileges on dems.* to admin@"%";
flush privileges;
grant select,insert,update,delete on dems.* to admin@'%';
创建一个用户,并授予其数据库所有权限
CREATE USER admin@'%' IDENTIFIED BY '123456';
grant all privileges on dems.* to admin@"%";
flush privileges;
grant select,insert,update,delete on dems.* to admin@'%';