mysql中创建用户和赋权限
- 创建oozie用户,%符号表示仅限于远程登录
create mysql.user 'oozie'@'%' identified by 'password';
- 赋予权限
-
all指所有功能,如果all被替换为select,则只有查询功能。
-
on后面的oozie指数据库名称,.*表示数据库中的所有表。
-
to后面oozie指账号。
grant all on oozie.* to 'oozie'@'%';
- 给某个用户分配某个数据中的表操作权限:(ecsoft.* 表示ecsoft里面所有的表)
grant all privileges on ecsoft.* to 'ecsoft'@'%' identified by 'password' with grant option;
flush privileges;
- 撤销权限:
REVOKE privilegexxx ON databasenamexxx.tablenamexxx FROM 'usernamexxx'@'hostxxx';
flush privileges;
- 修改密码:
SET PASSWORD FOR 'usernamexxx'@'hostxxx' = PASSWORD('newpasswordxxx');
flush privileges;
- 删除用户:
DROP USER 'usernamexxx'@'hostxxx';