Sams Teach Yourself SQL In 10 Minutes
5
th
Edition
MySQL Instructions
(current as of MySQL v8)
InstallingtheSoftware
1. You’llneedMySQL(orMariaDBinstalled),sodownloadeitheroneofthem.Thefreeversionof
MySQLiscalledMySQLCommunityServer,lookforitathttps://dev.mysql.com/downloads/.
2. Oncedownloaded,runtheinstaller.
3. TheinstallermayaskyouforaSetupType,selectDeveloperDefaultwhichinstallstheserver
and
basictools,includingMySQLWorkbench.(Don’tworryifyouseeerrormessagespertainingtoVisual
Studio).
4. Youcanacceptallthedefaultconfigurationsettings.
5. You’llbeaskedforarootpassword,enterapasswordandrememberwhatitisasyou’llneedit
whenyouconfigureMySQL
Workbench.
6. Finishtheinstallationandconfiguration.Youmaybeaskedforyourrootpassword.Whenthe
installercompletes,you’llhavearunningserver.
ConfiguringMySQLWorkbench
7. MySQLWorkbenchshouldopenautomaticallyoncetheserverinstallationhascompleted.Ifitdoes
not,openMySQLWorkbenchdirectly.
8. Intheleftside,underMySQLConnections,youshouldseeaboxnamedLocalinstanceMySQL.Ifitis
presentskiptostep14below.
9. Iftheinstanceis
notpresent,additmanually.Clickthe+nexttoMySQLConnectionstodisplaythe
SetupNewConnectiondia log.
10. SetConnectionNametolocalhost.
11. Specifytheuserloginandpassword(ifnouserwasspecifiedthentheloginwillberoot).
12. ClicktheTestConnectionbutton.
13.
Ifallok,clickOKtocreatetheconnection.Theconnectionwillnowbelisted,andinfutureyoucan
justdouble‐clickonitdirectly.
14. ClickonLocalinstanceMySQLtoconnecttothedatabaseinstance.Ifpromptedforapassword,
enterthepasswordyouprovidedduringinstallation.
15.
You’llthenseethemainMySQLWorkbenchscreen.
16. IfthereisalargeSQLAdditionswindowopen(it’lltakeuphalftherighthalfofthescreen)yo ucan
closeittomakemoreroomtowork.Todosolookatthetoprightofthescreen,you’ll
seethree