实验训练4：数据库系统维护.docx

《实验训练4：数据库系统维护.docx》由会员分享，可在线阅读，更多相关《实验训练4：数据库系统维护.docx（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、实验训练4：数据库系统维护1.数据库安全性【实验6-1】建立账户：创建一个用户名为Teacher,密码为T99999的用户；创建一个 用户名为Student密码为Slllir的用户。Details ror account newusepw。Login Account Limits Adminstrative Roles Schema PrivilegesLogin Name: TeacherYou may aeate multiple accounts with the same name to connect from different hosts.Authentication Type:

2、 Standardv*For the standard password and/or host based authentication, select Standard.Limit to Hosts Matdiing: | % and _ wildcards may be usedPassword:Weak password.Type a password to reset it.Confirm Password: *工Enter password again to confirm.Expire PasswordDetails for account Teacher)%Login Acco

3、uit Limits Administrative Roles Schema PriviegesLogin Name:StudentYou may create multiple accounts with the same name to connect from different hosts.Authentication T ype:StandardFor the standard password and/or host based authenticat)on, select Standard.Limit to Hosts Matching: % and _ wildcards ma

4、y be usedPassword:产*Weak password.Confirm Password:Typea password to reset it.Enter password again to confirm.Expre PasswordUserFrom HostStudent%Teacher%mysql.sessionlocalhostmysql.syslocalhostrootlocalhostSchemashoppingPrivieges SELECT：掰）愚 n Export/Import:电：fQ Wrapdd ImageCname Password phone_numbe

5、rEmailCreate timeCkind【实验 6-7分别使用 SELECT .INTO MySQL 命令、MySQL Workbench 完成 Shopping 数据库中会员表和汽车配件表的导出，查看导出结果。T Y V in IV V 191 I 3nt5* insert into clientkind vlues( /学生,)；OutputJ Action OutputTimai 145n3Action sded -fromckrt7fow4i|fetiMnedO 2 1453:34&TorCode 1142 INSERTocmnanddenedtouer *SbudertlocAo

6、*forUble cienttandW VZ i IIdelete fro clientkind where cid ;Output(5 Aden Output. Tbne AcwiQ 1 14:52:33 sdect fromderto 2 14 5334 mertm-rtk 必*M5.亨生)O 3 1454.11 de4ecdhoif for t4Ue cAerdund实验 6-8】分别使用 LOAD DATA、MySQUMPORT、MySQL Workbench 完成 Shopping 数据库中 会员表和汽车配件表的导入，查看导入结果。0“ r ao iwio o h 力 i - a n

7、j 31 update clientkiftd set 学生kid ;Output(5 AcbonCktpU. Time Actiono 1 14 52 33 4ec-fromcierO 2 145334 med rto c*ertknl vbe5，T)O3 14 54 11 deHe from denied whw od 6O4 14 5516 updMe cWrtknd Mt zme 学生 T where kij 17rowgumedEnor Code 1142 INSERT axwnand derwd Io umt 3udentfor latte cSertkWEnot Code 1142 DELETE mnod to ger SudMV)c- for l收 denfcmdEnor Code 1142 UPDATE cvMnd deried to user Student1ocaho, lor Ubie JtW