IT入门数据库指导01

《IT入门数据库指导01》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、IT入门数据库上机指导2013.6.26DalianUniversityofTechnology目录1绪论11.1MySQL安装11.2连接MySQL112作业中的表151绪论1.1MySQL安装岡lySQLSetupTizardWelcometotheSetupWizardforMySQLServer5.0TheSetupWizardwillinstallMySQLServer5.0release5.0.6onyourcomputer.Tocontinue,clickNext.WARNING:Thisprogramisprotectedbycopyri

2、ghtla*A'.MyNext>Cancel關IySQLServer5・0一SetupVizardInstallingMySQLServer5.0Theprogramfeaturesyousele匚tedarebeinginstalled.Please•A,aitwhiletheSetupWizardinstallsMySQLServer5,0.Thismaytakeseveralminutes.Status:Copyingn已yfilesCancellySQLServerInstanceConfiguration¥izardMySQ

3、LServerInstanceConfigurationConfiguretheMySQLServer5.0serverinstance.Pleaseselectaservertype.Thiswillinfluericememory,diskandCPUusage.IThisisadevelopmentmachin巴吕ndrr^nyotherapplications穴illberunonit.MySQLServershouldonlyuseaminimalamountof丿memory.OServerMachineSeveralserverapplic

4、ationswillbe「unningonthismachine.Choosethisoptionfory/eb/applicationservers.F^iySQLwillhavemediummemoryusage.ODedicatedMySQLServerMachineThismachineisdedicatedtoruntheMySQLDatabaseServer.Nootherserversrsuchasawebormailserver,willberun.MySQLwillutilizeuptoallavailablememory.

5、ext>CancelIySQLServerInstanceConfigurationVizardMySQLServerInstanceConfigurationConfiguretheMySQLServer5.0serverinstan匚e.Pleaseselectthedatabaseusage.Generalpurposedatabases.ThiswilloptimizetheserverfortheuseofthefasttransactionalInnoDBstorageengineandthehighspeedMylSAMstorageeng

6、ine.OTransactionalDatabaseOnlyOptimizedforapplicationserversandtransactionK穴ebapplications.ThiswillmakeInnoDBthemainstorageengine.NotethattheMylSAMenginecanstillbeused.ONon-TransactionalDatabaseOnlySuitedforsimplewebappliestionsrmonitoringorloggingapplicationsyaswellasanalysispro

7、grams.Onlythenon・trarisaiztionalMylSAMstorageenginewillbeactivated.Cancel1.2连接MySQL1、启动客户端如果系统安装了MySQLServer5.0,可以通过开始菜单T程序TMySQLTMySQLServer5.0->MySQLCommandClient启动Mysql命令行客户端。缶MySQLQfiMySQLServer5.0>■『：KySQLComandLin

8、、输入口令（在创建数据库的时候指定的。）成功3、查看数据库命令：Showdata