![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753843420.png)
图片来源:马凯亮
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640748518645.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640748924268.png)
图片来源:刘涛
root查询本机localhost数据库账户密码
CREATE USER `test1`;
SELECT HOST,USER FROM MYSQL.USER;
CREATE USER
'test3'@'localhost' IDENTIFIED BY '333333',
'test4'@'localhost' IDENTIFIED BY '444444';
GRANT SELECT ON myschool1.student TO test3;
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753279166.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753299148.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753305630.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753315676.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753332771.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753352064.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753374889.png)
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753388046.png)
错误代码: 1142DELETE command denied to user 'test3'@'localhost' for table 'student'
denied deny 拒绝
![](https://saas.bk-cdn.com/t/28fa19a1-bd4e-468d-b51a-cc1195795049/u/e41e744f-8a62-49c8-9e5b-0b3866856d0c/image1640753422848.png)
数据库下周五8点开始考试
1.有笔记本,电子试卷截屏
2.没有笔记本写在纸上。
文件夹的名字 学号后两位+名字+班级
数据库何老师邮箱:471874223@qq.com