还剩2页未读,继续阅读
文本内容:
【实验6-1】建立账户mysqluseshopping;DatabasechangedmysqlcreateUSERTeacher@%IDENTIFIEDBYT99999;QueryOK0rowsaffected
0.03secmysqlcreateUSERStudentIDENTIFIEDBY,S11111,;QueryOK0rowsaffected
0.00secmysql.【实验6-21用户授权mysqlGRANTALLONshopping.*TOTeacher®%WITHGRANTOPTION;QueryOK0rowsaffected
0.00secmysqlGRANTSELECTONshopping.*TOStudent%WITHGRANTOPTION;QueryOK0rowsaffected
0.00secmysql.【实验6-3】及删除表导入向导导出向导SELECT*FROMclient;INSERTINTOclientVALUES31哭1小冈>J3451,2345678I1456781J2021-10-116:55:3313;SELECT*FROMclient;DELETEFROMclientWHEREcid=2;SELECT*FROMclient;SELECT*FROMclient;1UPDATEclientSETcid=W;2SELECT*FROMclient;[SQL]UPDATEclientSETcid=9;[Err]1142-UPDATEcommanddeniedtouserStudentIocaIhostfortableclientDELETEFROMclientwherecid=5;SELECT*FROMclient;[SQL]DELETEFROMclientwherecid=5;[Err]1142-DELETEcommanddeniedtouserStudentC^localhostfortableclientINSERTINTOclientkindVALUES(3・刁、冈L■);SELECT*FROMclientkind;[SQL]INSERTINTOclientkindVALUES⑶小刚%[Err]1142-INSERTcommanddeniedtouserStudentOlocalhostfortableclientkind【实验6-4]1rb还原备份16新建备份电删^2021-10-1719:48:00••J「MySQ常规L-新建连接高级SSLSSHHTTPX连接名主机名或IP地址请口用户名密码Teacherlocalhost3306Teacher叼保存定码连接测试确定取消信息结果1概况状态cidImageCnamePasswordphone_numberEmailCreatetimeCkind►2笑〃阂234132456778902918372021-10-0116:55:382cidImage►2笑3哭CnamePasswordphone_numberEmailCreatetimeCkind小红234132456778902918372021-10-0116:55:382小刚3452345678456782021-10-0116:55:383cidImageCnamePasswordphone_numberEmailCreatetimeCkind►3英小刚345234567845678UPDATEclientSETcidSELECT*FROMclient;2021-10-0116:55:38=5;3cidImageCnamePasswordphone_numberEmailCreatetimeCkind►5英小刚3452345678456782021-10-0116:55:383cidImageCnamePasswordphone_numberEmailCreatetimeCkind►5巽小刚3452345678456782021-10-0116:55:383。