mysql更改用户权限

grant all on *.* to lisi@'localhost'  identified by '111111';

 

revoke all on *.*  from lisi@'localhost';

 

 

grant all on ecshop.*  to lisi@'192.168.1.%'

 

grant create,drop,insert,update,select on ecshop.goods to lisi@'192.168.1.%';