實(shí)驗(yàn)訓(xùn)練4：數(shù)據(jù)庫系統(tǒng)維護(hù)1.數(shù)據(jù)庫安全性【實(shí)驗(yàn)6-1】建立賬戶：創(chuàng)建一個(gè)用戶名為"Teacher,密碼為‘T99999'的用戶；創(chuàng)建一個(gè)用戶名為'Student'密碼為"Slllir的用戶。Detailsroraccountnewusepw。LoginAccountLimitsAdminstrativeRolesSchemaPrivilegesLoginName:TeacherYoumayaeatemultipleaccountswiththesamenametoconnectfromdifferenthosts.AuthenticationType:Standard v*Forthestandardpasswordand/orhostbasedauthentication,select'Standard.LimittoHostsMatdiing:|%%and_wildcardsmaybeusedPassword:Weakpassword.Typeapasswordtoresetit.ConfirmPassword:"?**工Enterpasswordagaintoconfirm.ExpirePasswordDetailsforaccountTeacher^)%LoginAccouitLimitsAdministrativeRolesSchemaPriviegesLoginName:〔Student Youmaycreatemultipleaccountswiththesamenametoconnectfromdifferenthosts.AuthenticationType: StandardForthestandardpasswordand/orhostbasedauthenticat)on,selectStandard.LimittoHostsMatching:%%and_wildcardsmaybeusedPassword:產(chǎn)…* Weakpassword.ConfirmPassword:Typeapasswordtoresetit.Enterpasswordagaintoconfirm.ExprePasswordUserFromHostStudent%Teacher%UserFromHostStudent%Teacher%mysql.sessionlocalhostmysql.syslocalhostrootlocalhostSchemashoppingPriviegesSELECT<LoginAccountLimitsAdmnstrativeRolesSchemaPrivilegesUserStudentFromHost%Teacher %mysql.sessionlocalhostmysql.syslocalhostrootlocalhostUserAcccwntsUserFromHostStudent%Teacher%mysql.sessionlocalhostmysql.syslocalhostrootlocalhost【實(shí)驗(yàn)6-2］用戶授權(quán)：將Shopping數(shù)據(jù)庫上SELECT.INSERT.DELETE.UPDATE的權(quán)限授予'Teacher'用戶：將Shopping數(shù)據(jù)庫上SELECT的權(quán)限授予'Student'用戶。SchemaandHostfieldsmayuse%and_wildcards.Theserverwimatchspecificentriesbeforewidcardedones.DetailsforacccxintTeacher^%LoginAccountLmtsAdmostraOveRolesSchemaPrivilegesSchema PrivlegesShoppy DELETE,INSERT,SELECT,UPDATESchemaandHostfieldsmayuse%and_wildcards.Theserverwilmatchspecificentriesbeforewidcardedones.ObjectRights□SaECTObjectRights□SaECT□INSKT□CREATE□ALIW【實(shí)驗(yàn)6-3】以'Teacher'用戶身份連接Shopping數(shù)據(jù)庫，分別執(zhí)行SELECT、INSERT、DELETE.UPDATE.CREATE操作，查看執(zhí)行結(jié)果；以'Student'用戶身份連接Shopping數(shù)據(jù)庫，執(zhí)行SELECT、INSERT、DELETE.UPDATE操作，查看執(zhí)行結(jié)果。TeacherSuccessfullymadetheMySQLconnectionInformationrelatedtothisconnection:Port:3306User:TeacherSSLnotenabledAsuccessfulMySQLconnectionwasmadewiththeparametersdefinedforthisconnection.DonWmt，1%1?■皿回1?select*fromautoparts;—ItGrid）Oara*Row,：I 11Ed?:星|矗品Expori/lmpoft:1Q|俗|WrapCellContent:交ApriApname imageJink1magejink2imageJnk3Introductionis.saleoldjxicePriceWeightisgei風(fēng)胎刷熱刷刷刷刷胎的墊鳳胎刷他

擋輪雨腳雨雨雨雨輪掄腳擋掄雨蜘1-1xxxxXXXXXXXXXXXXXXXXXXXXXXXX風(fēng)胎刷熱刷刷刷刷胎的墊鳳胎刷他

擋輪雨腳雨雨雨雨輪掄腳擋掄雨蜘1-1xxxxXXXXXXXXXXXXXXXXXXXXXXXXXXX2222xxxxXXXXXXxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxXx*xxxxxxxxxxx*YXxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx2222xxxxxxxxxxxXY*同胎刷墊刷刷刷刷胎般

擋輪雨腳雨雨雨雨輪輪風(fēng)胎刷他

擋掄雨Bln2.33500.9810.98230.0010.9810.9810.9810.98310.98310.9810.002.33500.9810.981.33500.989.99230.00329.99329.994.991.33500.989.99?in.no查看備份文件▼W【實(shí)驗(yàn)6-4］使用mysqldump匚具對查看備份文件▼WH。Ia獷只。I蜜I一?圍IDonlUmitinsertintoclientkindvalues（，'教陽'）；Output:?:?工?：?3?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?3?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?：?"?：?：?：?：?：?：?：?：?3?：?：：□PActionOutput ▼#TimeAction5 114:48:04insertintodientkmdvalues（6.教師）wV#IIWFI"I1?deletefromclientkindwherekid=|;Output：?：■：：?：■：?：?：?：?：?：?：■：?：[JActionOutputTimeAction114:48:04insertintoclientkindvalues（6.教師）214:48:50deletefromdientkindwherename=教師.314:50:17deletefromdientkindwherekid=5MMIFIXXVIBJI- sniumn ▼IRI▼JLUJ1updateclientkindsetname='教井T'wherekid=t;|Output:[JActionOutput#TimeActionMe*e114:48:04insertintoclientkindvalues（6.教師）1ro,O214:48:50deJetefromclientkindwherename"教師*EnoQ314:50:17deletefromclientkindwherekid=51fO）e414:50:57updatedentkindsetname=教師Twherekid=61ro,【實(shí)驗(yàn)6-5】對Shopping數(shù)據(jù)庫啟用二進(jìn)制日志，并且查看日志。SuccessfullymadetheMySQLconnectionInformationrelatedtothisconnection:Port:3306User:StudentSSLnotenabledAsuccessfulMySQLconnectionwasmadewiththeparametersdefinedforthisconnection.【實(shí)驗(yàn)6-6]使用mysqldump工具對Shopping數(shù)據(jù)庫進(jìn)行恢復(fù)，查看恢復(fù)前后Shopping數(shù)據(jù)庫的數(shù)據(jù)狀態(tài)。Query1x?01伊仔艮Ol酊I??甯IDontLimit1?select*fromclient;5100101xxxxXXXxxxxxxxxXXXXxxxxx張李5100101xxxxXXXxxxxxxxxXXXXxxxxx張李豐---子龍人五木子樹CYS1王李趙周IUC皿123456zs@126,com2019-01-0100:00:0012322213344765432018-02-0100:00:002WW234523452017-09-0800:00:003233333333332019-11-1100:00:0011122222222019-02-0300:00:002222222222222019-02-0300:00:0013211112019-11-3021:31:442nnn函sI；E?I；LU?ResultGrid超0FilterRows: ||Ed>：掰）愚＞§nExport/Import:電：fQ]WrapddImageCnamePasswordphone_numberEmailCreatetimeCkind【實(shí)驗(yàn)6-7]分別使用SELECT...INTO>MySQL命令、MySQLWorkbench完成Shopping數(shù)據(jù)庫中會員表和汽車配件表的導(dǎo)出，查看導(dǎo)出結(jié)果。TYVinIVV191I3nt5*insertintoclientkindv?lues(/學(xué)生,)；OutputJActionOutputTima

i145n3Actionsded-fromckrt7fow4i|fetiMnedO21453:34&TorCode1142INSERTocmnanddenedtou>er*Sbudert'@locAo*'forUblecienttand'WVZiI Ideletefro?clientkindwherecid?;Output(5AdenOutput ?.TbneAcwiQ114:52:33sdect'fromderto2145334mertm-rtk必*M<5.亨生)O31454.11de4e<efromdentkndwherecxl-67row8)ncUfnedEmxCodt11422S￡RT8HEnorCode1142DELETEcomanddenedtou?r,SluierteV>cdhoiffort4UecAerdund'實(shí)驗(yàn)6-8】分別使用LOADDATA、MySQUMPORT、MySQLWorkbench完成Shopping數(shù)據(jù)庫中會員表和汽車配件表的導(dǎo)入，查看導(dǎo)入結(jié)果。?0“raoiwiooh? ??力i-anj31updateclientkiftdset??學(xué)生「kid";Output(5AcbonCktpU ?.TimeActiono1145233?4ec?-fromcier<O2145334medrtoc*ertknlv?be^5，T±')O 31454