MySQL——4.DCL 数据控制语言



DCL(了解)---------------------------------------------------------------------------------------------------------------------------------------------------------

• 创建用户

  create uesr 用户名@地址 identified by '密码';

  例：CREATE USER user1@192.168.1.47 IDENTIFIED BY ‘123’;

  [user1用户只能在localhost这个IP登录mysql服务器]

  CREATE USER user2@’%’ IDENTIFIED BY ‘123’;

  [user2用户可以在任何电脑上登录mysql服务器]

   

• 给用户授权

  grant 权限1, … , 权限n on 数据库.* to 用户名;

  例：GRANT CREATE,ALTER,DROP,INSERT,UPDATE,DELETE,SELECT ON zhidisoft.* TO user1@localhost;

  GRANT ALL ON mydb1.* TO user1@localhost;

   

• 撤销授权

  revoke 权限1, … , 权限n on 数据库.* form 用户名;

  例：REVOKE CREATE,ALTER,DROP ON itheima11.* FROM user1@localhost;

   

• 查看用户权限

  show grants for 用户名

  例：SHOW GRANTS FOR user3@localhost;

   

• 删除用户

  drop uesr 用户名

  例：DROP USER user1@localhost;

   

• 修改用户密码

  USE mysql;

  update uesr set password=password(‘密码’) where user=’用户名’ and host=’ip’

  flush provoleges;

  例：UPDATE USER SET PASSWORD=PASSWORD('1234') WHERE User='user2' and Host=’localhost’;

  FLUSH PRIVILEGES;