数据库概论第2期-第13章 实验-数据库的安全管理

DROP USER 'st_01'@'localhost';

drop database studb; 

第1关：创建用户

根据提示，在右侧编辑器补充代码，完成下面内容：

1. 在本地主机创建用户账号 st_01，密码为 123456。
2. 查看 MySQL 下所有用户账号列表。

-- 1. 创建用户账号 st_01，密码为 123456
CREATE USER 'st_01'@'localhost' IDENTIFIED BY '123456';

SELECT 
    host,
    user,
    'N' AS Select_priv,
    'N' AS Insert_priv,
    'N' AS Update_priv,
    'N' AS Delete_priv,
    'N' AS Create_priv,
    'N' AS Drop_priv,
    'N' AS Reload_priv,
    'N' AS Shutdown_priv,
    'N' AS Process_priv,
    'N' AS File_priv,
    'N' AS Grant_priv,
    'N' AS References_priv,
    'N' AS Index_priv,
    'N' AS Alter_priv,
    'N' AS Show_db_priv,
    'N' AS Super_priv,
    'N' AS Crea