mysql 权限管理 grant revoke

时间:2021-11-08 16:19:59

grant all privileges  on  database.table to 'user'@'ip' identified by 'passwd' with grant  option;

grant  select,insert on mt.* to 'mtp'@'192.168.25.20' identified by 'meal123456' with  grant  option;

 

删除权限

revoke drop on mt.* from 'mtp'@'192.168.25.20';

查权限

show  grants for mtp@'192.168.25.20';

 

看你的mysql现在已提供什么存储引擎: mysql> show engines; 看你的mysql当前默认的存储引擎: mysql> show variables like '%storage_engine%'; 你要看某个表用了什么引擎(在显示结果里参数engine后面的就表示该表当前用的存储引擎): mysql> show create table 表名;