Ifyouappreciatethiseducation, pleasethinkaboutgoingtoElithecomputerguydotcomandoffering a onetimeormonthlyrecurringdonation.
Welcomeback.
Sointoday's video, I'm goingtoshowyouhowtocreate a labenvironmentinorderforyoutodoyourmysequelprojects.
Soaswegoforwardintofutureclasses, I'm goingtoshowyouhowtorun a sequelstatementsandmysequel.
Andobviouslywe'regoingtoneed a labenvironmenttoeallowyoudothat.
Sobasicallywhatwe'regoingtobedoingtodayiswe'regoingtobespendingup a virtualmachinewith a bunto a desktopoperatingsystemonit.
We'rethengoingtobeusingsomethingcalledTaskCellusingTaskCellthatwillallowustoinstall a lampserversthatthey'llbeLennoxApache, mysequelandPHPand a nice, easy, youknow, waytodothings.
Andthenwe'regoingtolearnthatlogintomysequel.
I'm goingtoshowyou a littlebit, basicallyshowingyouthatmysequelactuallyworks, andthenwe'regoingtocallit a daysothatwecangointothenextclassis.
Soifyoualreadyhave a mysequeldatabaseserverupandrunning, youdonothavetowatchthisvideo.
Butanyways, a lotoftimes I getoldtimerswatchingthesevideosforNubes, andthentheyjustripmeinto a holebecause I'm nottakingthenubestheproperwayofdoingthingsright.
Andunfortunately, a lotofpeoplejustsimplygetconfusedandtheygiveup.
Sooneofthingsthat I doagain, a lotofpeoplecomplainandbitchandmoanabouthow I doclassesisbecause a lotoftimeforthesenewclasses, I juststripoutsecurity, andwe'renotevengonnaworryaboutsecurity.
We'renotgonnaworryabout a lotofthesebestpracticesbecausethosebestpracticesthatsecuritymakesthingsveryconfusingforpeopleonagain.
I justrealizedtoomanypeoplewouldmostlikelydropoutsimplybecauseitcouldgetPHPMiamiandwork.
Andthenthat's notgoodforanybody.
Sobyusingthistaskcell, thisissimple.
It's easyifyouunderstandhowtoinstallthenewbondtooperatingsystemonto a virtualmachine, I'llshowyouhowtousetestcell, andyou'llliterallyhavemysequelupandrunningin a coupleofminutes.
Sowiththat, let's gettotheclass.
Soforthisparticularlab, I'm goingtobeusingvirtualboxtocreateaninstanceof a buntodesktop 18.4 Whenthatisupandrunning, wewillthenuseTaskCelltobeoveninstalledlampLennox a Paki, mysequel, PHP.
Oryoucanhave a physicalphysicalboxagaininstalled U Bahntodesktoponthatandthenruntaskcell, andyouwillbeYouwillhaveyourlabenvironmentsothatlet's gooverthecomputerandwe'llshowyouhowthisworks.
Sohereweare, myMacbookproandagain I'vegot a virtualboxopen.
Sotheinstancewe'regoingtobeusingtodayis a soupontodesktopagain 18.4 And I'vecreated a versionspecificallyforthis.
What I wouldsayistryingtocreateonethat, like a defaultversionofwhateveroperatingsystemthatyou'redealingwithandthenwhenyoudodifferentprojectswhenyoudodifferentclasses, youcango, andyoucanclonethatversion.
Basically, we'reselectingwhatkindofserverwewanttocreateandthenwehitenterandthenthisthislittlelittlethingpulpcomesupSohereagainyoucanseethere's lotsofdifferenttypesofserversthatyoucancreatereallyrathereasily a d.
N s serveryou'vegot, youknow, thelampserverthatwe'regonnabedoinglubeontwothingsandmailserver, printserver, sambafileserver, thetests l wasactually a prettyeasy, prettycoollittlepieceofsoftwareonisaneasywaytobeabletospendupserversagain.
Soyouhitthespacebarandthenyouhave a tabforOKandthenyouhitokay, andnowit's goingtogothroughwhenit's goingtoinstallandretrieveallofourpackages.
Forus, whichisprettysimple.
Quickprocessagainaslongasyouhave a computerthat's, youknowrelativelyrecently.
No, nothinghereistoocomplicatedortoohard, soit's goingthroughoruptoabout 91% here.
Configure a pattern.
Yousee, mysequelwasdoingPHPbefore, right?
Soisinstalling, andallofthesedifferentserviceisforyousothatyoudon't havetoindividuallyinstallthemsothatthat's whatmakesitsuch a such a nicethingitmakesitsoeasyfordeploying a lampserversoagainisdoingthemodfilestoknowthat.
Andsonow, nowwe'reback.
Right?
Sothecoolparthere, Right?
Sowegotofirefoxversus a nuisanceofthelampserviceor a lampserveris a webserver s o.
WesimplyopenupfireFox.
Andjusttomakesurethatthelampserversactuallyinstalled, we'regoingtogoto 1 27.0 point 0.1.
Sowhatthisiscalledisthislittleloopbackaddress?
Sothisisthe I.
P.
Addressofyourcomputer.
Sowhetheryou'reon a Windowscomputer, whetheryou'reonLennoxandcuterwhenyou'reon a matcomputer, theloopbackaddressbasicallyloopsyoubackintoyourowncomputer s.
Soifyou'rewith a webbrowser, whatthiswilldoisLukeyoubackintotheWebserverthatshouldberunningonyourparticularcomputer.
Sowe'regoingtoenterandthereTherewego.
WegottheApachetowhoboughttodefaultpay.
ThisistheDefoewelcomepageusedtotestthecorrectoperationof a pathyoutoserverafterinstallationonyoubunk.
Twosystems.
So, basically, ifyougetthispage a path, youtooisworkingorit's workinggoodenough.
SoifwecreateusersandthefutureBombandTimandSuewhenallthosedifferentusers, thoseuserswillpopupherenowoneofproblemsandoneofthereasonswhyyouneedtoknowhowtobeabletowritesequelstatementstoactuallybeabletogiveyoutheproperinformationiswiththiswhat I didhere.
Sosomethingtorealizeagain, whatgetspeoplereallyconfusedisifyoudoselectandthenallso a lotoftimesyou'llseesequelstatementswhereitsaysselectalsobasicallyselectallthecolumnsand a particulartableprintoutalltheinformationtable.
Butifyoudothatfor, like, theusertable, whatyou'regonnagetis a lotofGod.
SoSo, yeah, I haveah, havefunwiththis.
Andthisiswhyagain, it's veryimportant.
UnderstandhowsecretworksBecausethedifferencebetweensomethingusefulasinyoucanseealltheusernamesininthisparticulardatabaseserverversusgobbledygookisbasicallywhetherornotyoucanwrite a properstate.
It'lljusttake a littlebitmoreeffortandoneofmyconcernsthatyoumightrunintosomeproblemsagain.
TaskCellinstallsApacheinmysequelPHPandthemodulesaltogetherinsomethingfunctional, whereasifyoudoityourselfandyouforget a molecule, ifyouforget a configuration, thenallof a suddenyou'resayingthey'retryingtotroubleshootthoseproblemsratherthanactuallytryingtobeabletolearn.
But I'm tryingtoteachyou s sothat's why I wouldrecommendtask.
They'llgetin a realproductionenvironment.
YouMay, youmayquestionmaydecidetotogo a differentroutethereagain, attheendofthedayto I wasgoingtodotherestoftheSiri's usingsomethingcalledPHP.
Myadmin.
PHP.
Miamiis a veryusefultoolagain.
I stilluseitonmyWebproduction.
WebsterwasmyWebserversthatactuallyruninusePHPatMiamijustfine, butapparentlyagain, forsomereason, theversionofPHP, myadminthat's inthe U BahntorepositoriesdoesnotplayLieslavewith 18.4 Andso, inordertomakethatworkbasicallyducttapethattogether, itcouldbe a bitof a paintothereason I decidednottousePHP.
MyadminforthisparticularSiri's simply I don't wanttogetinthatwholetroubleshootingprocess.
I don't wanttolosepeoplebecauseyoustarthaveproblemsinstallingpH.
Allright, youstarttalkingaboutthePHPdenyand I filerightafterhistalktostarttalkingaboutmysequelstatements, andthey'regonnathinkPHPdotand I filesofmysequelstatements.
Haveanythingintheworldtodowith, youknowthepsbdoton I file.
It's a real P H B.
A PakiisforyourApache, mysequelsoyoumightseewhattheseairdifferentthings, butoneoftheproblemsthatpeoplerunintoastheytrytolearnsomanythingsatonetime.
Andthentheygetconfusedaboutwhatwhatrelatestowhatis a virtualhostagain, Youstarttalkingaboutunpackingandvirtualhosts, andtheystartthinkingthathasonlywithmySequelslikeNo, no, let's justlet's justletlet's justfocusinonmysequelLearnMySeatwilllearnsequelstatements, andthenonceyoulearnmysequel, thenwecanstartinwith a PHPthenwecanstartlearningwithdealingwithApache.
Andthenonceyouunderstandallthat, thenwecametogotomoreadvancedconfigurationsthatyouwouldactuallyputoutin a productionenvironment.
Sobasicallytypesomethinginthatkeephittingandherjusthad a semicolonatsomepointthatwillactuallyrunit, andthenyougettotallyconfused.
ItjustfrustratedExit e x I t.
We'llgetyououtofthere.
So, asalways, I enjoydoingthisclassandlookforwardtothenextone.
Apparently, thetypeofcontentyoujustsawisnotwhatSusan W.
WantsforthefutureofYouTube.
ThismeansthatrecommendationsbyYouTubetothischannelhavedroppedmassively, andviewsarebecoming a comicallysmall I hatetoask.
I usedtosay I wouldneverask, butifyoucouldsubscribelikecommonandmostimportantly, sharethevideosthatyouappreciate, thatmayhelpslowthedeathofthischannel.