mysql权限管理及账户创建

<创建localhost及host>

本地用户

create user '用户名'@'localhost' identified by '密码';

 远程用户

%代表任意

create user '用户名'@'客户端ip' identified by '密码';

create user '用户名'@'%' identified by '密码';

create user '用户名'@‘127.0.0.%’ identified by '密码';

<权限管理>

添加权限

grant 添加的命令 on 等级 to '用户名'@'localhost';

grant select on *.* to 'demo'@'localhost';

 精确到表

grant select on 数据库.表名 to '用户名'@'localhost';

grant select on demo.t1 to 'hz'@'localhost';

精确到记录

grant select(字段,字段),updata(字段,字段) on 数据库.表名 to '用户名'@localhost;

grant select(id,name),updata(id) on demo.t1 to 'demo'@'localhost';

<拿回权限>

revoke 拿回的命令 on *.* from '用户名'@'localhost';

revoke all in *.* from 'demo'@'localhost';