10 MySQL--权限管理

1、创建账号 # 本地账号 create user ‘egon1‘@‘localhost‘ identified by ‘123‘; # mysql -uegon1 -p123 # 远程帐号 create user ‘egon2‘@‘192.168.31.10‘ identified by ‘123‘; # mysql -uegon2 -p123 -h 服务端ip create user ‘egon3‘@‘192.168.31.%‘ identified by ‘123‘; # mysql -uegon3 -p123 -h 服务端ip create user ‘egon3‘@‘%‘ identified by ‘123‘; # mysql -uegon3 -p123 -h 服务端ip 2、授权
　　　　权限控制力度依次降低 user:*.* db:db1.* tables_priv:db1.t1 columns_priv:id,name
　　　　　# 库级别 grant all on *.* to ‘egon1‘@‘localhost‘; # 授权grant *.* 授权所有级别 grant select on *.* to ‘egon1‘@‘localhost‘; revoke select on *.* from ‘egon1‘@‘localhost‘; # 回收权限revoke
　　　　　授权库　 grant select on db1.* to ‘egon1‘@‘localhost‘; revoke select on db1.* from ‘egon1‘@‘localhost‘; 授权表 grant select on db1.t2 to ‘egon1‘@‘localhost‘; revoke select on db1.t2 from ‘egon1‘@‘localhost‘; # 回收权限
授权表下的字段 grant select(id,name),update(age) on db1.t2 to ‘egon1‘@‘localhost‘;

 select * from t2 ,,,        * 代表所有

10 MySQL--权限管理

标签：mysql   权限控制   style   sql   rom   span   本地   权限   服务端