SQL--DCL(管理用户，授权，修改密码)

1.添加⽤户

--语法：
        create user ⽤户名@'IP地址' identified by 密码
-- 当前的⽤户只可以在本机登录。
        create user magic@'127.0.0.1' identified by "123";
-- 任意Ip 都可以登录的⽤户
        create user magic@"%" identified by "123";

2.查看⽤户

-- 先进⼊ 名为 mysql 的数据库
        use mysql;
-- 查看⽤户
        select * from user;
         Host | User | Password 
        select host,user,password from user;

3.修改⽤户的密码

-- 使⽤ root ⽤户来登录
        update user set password = password("magic") where user = "magic";
        set password for magic@"127.0.0.1" = password("123");
-- 修改完毕之后要进⾏权限刷