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;