创建用户

create user ‘xcshop’@’%’ identified by ‘xcshop’;

设置用户指定数据库权限

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE VIEW, SHOW VIEW ON `xiaocha`.* TO ‘xcshop’@’%’;

刷新权限

flush privileges;