Mysql 用户 权限

1.创建用户名，并赋予全部权限 与某个数据库

CREATE USER 'dbUserDev'@'%' IDENTIFIED BY '123456';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,INDEX, ALTER, CREATE VIEW,SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER,execute on mysql.* to 'dbUserDev'@'%';
FLUSH PRIVILEGES; 
 

2.创建用户名，只赋予增删改查权限

CREATE USER 'dbUserPDD'@'%' IDENTIFIED BY 'xhjc*8@#Efski';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,INDEX, ALTER, CREATE VIEW,SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER,execute on mysql.* to 'dbUserPDD'@'%';
FLUSH PRIVILEGES;