怎么安装mysql并导入数据

安装mysql

1,下载邮件中的mysql安装包

2,双击运行安装

博MySQLServer5.5Setup

WelcometotheMySQLServer5.5Setup

Wizard

TheSetupWizardwillinstallMySQLServer5.5onyour

computer.ClickNexttocontinueorCanceltoexittheSetup

Wizard.

Copyright(c)2000^201Oracleand/oritsaffiliates.All

rightsreserved.

i爆lySQLServer5.5SetupfZM!fx

ChooseSetupType

Choosethesetuptypethatbestsuitsyourneeds

经典安装

InstHIkthemci5tLDOrinnprogramfeatures.Recommendedformostusers.

Custom

Allowsuserstochoosewhichprogramfeatureswillbeinstalledandwheretheywillbe

installed.Recommendedforadvancedusers.

Complete

Allprogramfeatureswillbeinstalled.Requiresthemostdiskspace.

BackCancel

lySQLServer5.5Setup

ReadytoinstallMySQLServer5.5

ClickInstalltobegintheinstallation.ClickBacktorevieworchangeanyofyourinstallation

settings.ClickCanceltoexitthewizard.

BackCancel

CompletedtheMySQLServer5.5Setup

Wizard

ClicktheFinishbuttontoexittheSetupWizard.

Finish

启动配置

lySQLServerInstanceConfigurationWizard

TheConfigurationWizardwillallowyoutoconfigurethe

MySQLServer5.5serverinstance.ToContinuejclick

Next.

WelcometotheMySQLServerInstance

ConfigurationWizard1.0.17.0

■ySQLServerInstanceConfigurationTizard

MySQLServerInstanceConfiguration

ConfiguretheMySQLServer5.5serverinstance.

Pleaseselectaconfigurationtype.

*DetailedConfiguration

［里Choosethisconfigurationtypetocreatetheoptimalserversetupfor

l►rthismachine.

StandardConfiguration

I'*rKUsethisonlyonmachinesthatdonotalreadyhaveaMy5QLserver

；installation.Thiswilluseageneralpurposeconfigurationfbrtheserver

thatcanbetunedmanually.

<Back\Next>Cancel

Pleaseselectaservertype.ThiswillinfluencememoryAdiskandCPUusage.

#peveloperMachineA

Thisisadevelopmentmachinejandmanyotherapplicationswillberun

onit.My5QLServershouldonlyuseaminimalamountofmemory.

ServerMachine

Severalserverapplicationswillberunningonthismachine.Choosethisoptionfor

web/applicationservers.My5QLwillhavemediummemoryusage.

DedicatedMySQLServerMachine

ThismachineisdedicatedtoruntheMySQLDatabaseServer.Noother

serversjsuchasawebormailserverwillberun.MySQLwillutilizeuptoallavailable

memory.

<BackINext>Cancel

■ySQLServerInstanceConfigurationVizard

MySQLServerInstanceConfiguration

ConfiguretheMySQLServer5.5serverinstance.

Pleaseselectthedatabaseusage.

*MultifunctionalDatabase!

Generalpurposedatabases.Thiswilloptimizetheserverfortheuseof

thefasttransactionalInnoDBstorageengineandthehighspeed

Myl5AMstorageengine.

TransactionalDatabaseOnly,

Optimizedforapplicationserversandtransactionalwebapplications.

ThiswillmakeInnoDBthemainstorageengine.Notethatthe37*,MyI5AM

enginecanstillbeused.

Non-TransactionalDatabaseOnly

E

Suitedforsimplewebapplications]monitoringorloggingapplications

jj'aswellasanalysisprograms.Onlythenon-transactionalMyl5AMstorage

enginewillbeactivated.

<BackNext>Cancel

■ySQLServerInstanceConfigurationVizardX

MySQLServerInstanceConfiguration

ConfiguretheMySQLServer5.5serverinstance.

Pleasesetthenetworkingoptions.

EnableTCP/IPNetworking

EnablethisloallowTCP/IPconnections.Whendisabled]onlylocalconnections

throughnamedpipesareallowed.

PortNumber:IcjcHId>1Addfirewallexceptionforthisport

Pleasesettheserver5QLmode.

环EnableStrictMode

Thisoptionforcestheservertobehavemorelikeatraditional

databaseserver.Itisrecommendedtoenablethisoption.

KySQLServerInstanceConfiguration¥izard

MySQLServerInstanceConfiguration

ConfiguretheMySQLServer5.5serverinstance.

PleasesettheWindowsoptions.

PInstallAsWindowsService

&ThisistherecommendedwaytoruntheMySQLserver

；'?♦onWindows.

ServiceName:|MySQL_^J

17LaunchtheMySQLServerautomatically

IncludeBinDirectoryinWindowsPATH

Checkthisoptiontoincludethedirectorycontainingthe

server/clientexecutablesintheWindowsPATHvariable

sotheycanbecalledfromthecommandline.

<Back]?N斑.Cancel

■ySQLServerInstanceConfigurationTizard

MySQLServerInstanceConfiguration

ConfiguretheMy5QLServer5.5serverinstance.

Entertherootpassword.

Retypethepassword.

remote

设置密码,输入两次

CreateAnAnonymousAccount

Thisoptionwillcreateananonymousaccountonthisserver.Pleasenotethatthis

canleadtoaninsecuresystem.

<BackINext>Cancel

lySQLServerInstanceConfigurationTizard

MySQLServerInstanceConfiguration

ConfiguretheMy5QLServer5.5serverinstance.

Readytoexecute...

Prepareconfiguration

Writcconfigurationfile

Startservice

Applysecuritysettings

Pleasepress[EHecuteltostarttheconfiguration.

<BackExecuteCancel

lySQLServerInstanceConfigurationVizard

MySQLServerInstanceConfiguration

ConfiguretheMySQLServer5.5serverinstance.

Processingconfiguration...

4Piepareconfiguration

电VHteconfigurationfile(C:\ProgramFilesWyGQLWySQLServerS5Vny.ini)

MSiarts

0A>plysecuritysettings

Configurationfilecreated.

WindowsserviceMySQLinstalled.四项全部打勾

Servicestartedsuccessfully.

Securitysettingsapplied.表示安装成功

Press[Finish]toclosetheWizard.

<BackI|FinimZancel

导入数据

1,在开始中找到mysql并打开

2,输入安装时设置的密码进入

ESIMySQLCommandLineClient

PBIMySQLCommandLineClient

Enterpassword：xn

WelcometotheMySQLmonitor.imandsendwith；or

¥ourMySQLconnectionidis4

Serverversion：5.5.11MySQLCommunityServer<GPL>

Copyright<c>2000,2010,Oracleand/oritsaffiliates.Allrightsreserved.

OracleisaregisteredtrademarkofOracleCorporationand/orits

affiliates.Othernamesmaybetradenarksoftheirrespectiue

owners.

Type,help；*or’71'forheIp.Type*Xc*toclearthecurrentinputstatement.

mysql>.

3,创建数据库

createdatabaeshop;（esh为数据库名，具体名称以实际项目为准）

浮现QueryOK,表示创建成功

ESIMySQLCommandLineClient

Enterpassword：痒

UelcometotheMySQLmonitor.Commandsendwith；()PXg.

VOLIPMySQLc(»nnectionidis6

Serueruersion:5.5.11MySQLCommunitySeriiervGPL>

Copyright<c>2000.2022,Oracleand/oritsafTiliates.Allrightsreseruvd.

OracleisaregisteredtrademarkofOracleCorporationand/orits

affiliates_______Othernamesmayhetnidcmurksoftheirrespectiue

owners.

Type1heIp：1OF1\}iJfOFheIp_Type1Xc1tocTeartheCLirrentinputstatement

mysql>createdatabaseeshop；

QueryOK,Irowaffected<0.00seo

mysql>.

4,使用新创建的数据库useeshop;(esh为数据库名，具体名称以实际项

目为准)

浮现Databasechanged表不成功

BSMySQLCommandLineClient

Enterpassword：

WelcometotheMySQLniunitor.Commandsendwith；orW.

VOLIPMySQLconnectionidis6

Serueruersion:53_11MySQLCommunitySeruer(GPL)

Copyright<c>20(H),2022,Oracleand/oritsuHIliutes.Allrightspeserued.

OracleisaregisteredtrudemarkofOracleCorporationand/orits

af£iliates.Othernamesmaybetradenarksoftheiprespectiuc

owners.

Type1heIp；1OP1\)iJfOPheIp.Type1\c*toclearthecurrentinputstatement.

mys(|l>createdatabaseeshop：

QueryOK.1rowafTcctcd<0.00sec>

mysql>useeshop：

Database