:-: DCL-管理用户 1.查询用户 ``` -- 访问mysql USE mysql -- 查询user SELECT * FROM user; ``` 2.创建用户 ``` CREATE USER ‘用户名’@‘主机名‘ IDENTIFIED BY '密码'; ``` 3.修改用户密码 ``` ALTER USER '用户名'@‘主机名’ IDENTIFIED WITH mysql_native_password BY '新密码'; ``` 4.删除用户 ``` DROP USER '用户名'@‘主机名’; ``` ``` -- 创建用户 itcast ，只能够在当前主机localhost访问，密码123456； create user 'itcast'@'localhost' identified by '123456'; -- 创建用户 heima , 可以在任意主机访问该数据库，密码123456； create user 'itcast'@'%' identified by '123456'; -- 修改用户 heima 的访问密码为1234 alter user 'heima'@'%' identified with mysql_native_password by '1234'; --删除itcast@localhost用户 drop user 'itcast'@'localhost'; ```