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 表名;