MySQL给某个用户给某个库表设置权限

-- 用root（最高权限的用户）进行以下操作


-- 创建数据库：emc_power
CREATE DATABASE emc_power DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 创建用户，并只给emc_power库所有表增删改查的权限：用户名--emc_power 密码--Zxit@2018  

grant SELECT,INSERT,UPDATE,DELETE ON emc_power.* to 'emc_power'@'%' identified by 'Zxit@2018' with grant option;
 -- 刷新权限 
flush privileges;