grant 权限名称 on db.tableto username@'192.168.88.105';
例如:
grantselecton db.tableto username@'192.168.88.105';(授予用户查询table表的权限)
grantallon *.* to username@'192.168.88.105';(授予用户所有数据库和表的权限)
flush privileges;(刷新权限)
回收用户特定权限
revoke 权限名称 on db.table from username@'192.168.88.105';
例如:
revoke selecton db.table from username@'192.168.88.105';
revoke all on *.* from username@'192.168.88.105';
用户管理创建用户create user username@'192.168.88.105' identified by '123456';create user username@'%' identified by '123456';删除用户drop user username@'192.168.88.105', username@'%'; 权限管理查看用户权限show grants