CREATE USER 'pcms'@'%' IDENTIFIED BY '123456'; -- 创建用户pcms,密码为123456GRANT SELECT,INSERT,UPDATE,DELETE ON database1.* TO 'pcms'; -- 赋予pcms账号,database1库的增删改查权限。FLUSH PRIVILEGES; -- 刷新