mysql创建用户，并指定数据库权限

创建用户myuser并赋予dev数据库权限

create user myuser@'%' identified by 'root';
grant all privileges on dev.* to 'myuser'@'%';
flush privileges;
 

创建权限/回收权限

grant all on *.* to dba@localhost;
revoke all on *.* from dba@loc
 
revoke all privileges on db1.* from 'myuser'@'%';
grant all privileges on db2.* to 'myuser'@'%';
flush privileges;

备注：

//低版本数据库
create user '用户民'@'%' identified by '密码';
//高版本数据库
create user '用户名'@'%' identified with mysql_native_password by '密码';