Placeholder Image

字幕表 動画を再生する

  • creating these classes requires equipment and service.

  • Is that cost money?

  • If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

  • Welcome back.

  • So in today's video, I'm going to show you how to create a lab environment in order for you to do your my sequel projects.

  • So as we go forward into future classes, I'm going to show you how to run a sequel statements and my sequel.

  • And obviously we're going to need a lab environment toe allow you do that.

  • So basically what we're going to be doing today is we're going to be spending up a virtual machine with a bun to a desktop operating system on it.

  • We're then going to be using something called Task Cell using Task Cell that will allow us to install a lamp servers that they'll be Lennox Apache, my sequel and PHP and a nice, easy, you know, way to do things.

  • And then we're going to learn that log into my sequel.

  • I'm going to show you a little bit, basically showing you that my sequel actually works, and then we're going to call it a day so that we can go into the next class is.

  • So if you already have a my sequel database server up and running, you do not have to watch this video.

  • This is just for new people.

  • Basically, if you need some type of lab environment so that you can actually run my sequel statements, that is what we're going to do for you today.

  • Now, warning.

  • Warning Will Robinson warning.

  • Warning.

  • I'm sure some of the old timers out there because for some reason, I get old timers watching these videos, which I don't really understand what they're doing.

  • These many as our new people new jobs go away, old timers go away.

  • But anyways, a lot of times I get old timers watching these videos for Nubes, and then they just rip me into a hole because I'm not taking the nubes the proper way of doing things right.

  • So basically, we're gonna be using something called Task Cell today.

  • And so task sells a very easy way to get a lamp server and other types of a bunch of servers up and running.

  • And a lot of people dislike it because it basically installs.

  • You're my sequel, your PHP, your Apache and nonstandard locations.

  • It can be a bit a bit quirky to deal with.

  • If you're actually dealing with things in the production environments.

  • A lot of people disc like using tasks so well again.

  • Do you remember when either I'm trying to teach you folks classes?

  • I'm literally I'm literally trying to teach you a za little a cz possible.

  • Now that may seem like a joke, and that may seem snarky, but it is actually true.

  • I'm trying to, ah, hyper focus on whatever the hell it is that I'm trying to explain to you and not worry about all the other stuff.

  • I was in your shoes 20 years ago, and I know what it's like when an instructor is trying to teach you networking and security and operated system and everything at one time.

  • When you're a new person, you know, understand anything, right?

  • All this crap is getting lumped on onto your brain at the exact same same moment, and it's very hard to discern what the hell is what.

  • What is security and what is the actual application is what is networking and what is all of this different stuff.

  • And unfortunately, a lot of people just simply get confused and they give up.

  • So one of things that I do again, a lot of people complain and bitch and moan about how I do classes is because a lot of time for these new classes, I just strip out security, and we're not even gonna worry about security.

  • We're not gonna worry about a lot of these best practices because those best practices that security makes things very confusing for people on again.

  • They give up.

  • So we're gonna do is we're gonna hyper focus just on my sequel.

  • So you get comfortable using the my sequel database.

  • And then once you understand that in later classes we can talk about how to secure the my sequel database and out how to do things properly.

  • So I will give you that one warning with again creating this particular lab, the old timers out out.

  • They're probably going to bake at you if you actually do this in the real world again.

  • One of the other things we will be using a bun to 18.4 in this particular class, and again we're going to be using a task cell to install the lamp server.

  • Something to keep in mind is, I actually had planned take you folks how to use my sequel using something called PHP My admits opiate.

  • Could be my admin is actually a gooey a graphical user interface that you can use in order to act interact with my sequel.

  • And I thought that would be an easy way of tea.

  • Can you folks my sequel again by the problem?

  • The problem is, I have used Ph.

  • B.

  • I at my admin for years now.

  • 13 14 years, probably, and I've never had an issue with it in the past.

  • To be honest with Theo, Uh, PHP my admin is the standard interface that you will use.

  • So if you use a share hosting platform or if you use some kind of servers, cloud based servers in order to interact with your my single database, you'll most likely use something called PHP by admit and again in the past, all you have to do is pseudo app.

  • Hyphen get installed.

  • PH be my admin do a couple of commands, and it was up and running, and it was working perfectly, and there are no issues well again, Lennox World, the real computer world, apparently.

  • Apparently, there's a problem.

  • You want to 18.4 and the version of PHP, My admin that's in the repositories.

  • And so, basically, in order get PHP my admin work game.

  • You have to install it.

  • But then you have to download it from PHP, my admin.

  • And then you have to do these other configurations, and then you have to do some troubleshooting in order to get PHP Miami and work.

  • And that's again one of those places where I realized, Oh, this is probably getting too complicated, especially for new people.

  • And so we're going to skip that.

  • So again we were going to be using PHP, my admin for the classes going forward.

  • But again, apparently for some reason, for some reason, you bun to 18 point before does not like the pH.

  • Be my admin that's in the repositories and get a pH.

  • Be my admin up and running.

  • I was going through all the steps, and I was going through all the routines to make it work and went, Wow, this is a bit of a pain in the butt.

  • So those were just some warnings for you and some things to be thinking about with these classes were just going to be focusing, showing you how to do sequel statement showing you how to create databases in certain out into databases.

  • They pulled that out of that.

  • The databases, that type of thing on DSO.

  • After looking at it, I just decided it would be better just to use my sequel from the actual command, prompt and go from there again.

  • It is important to understand the technology world a CZ.

  • They say There's 1000 ways to skin a cat, right?

  • Any time you're trying to accomplish something in the technology world, there's usually a diff about a dozen different ways you can go about doing it.

  • And so one of the things is as a technology of professional, you have to think about your user.

  • You have to think about who you're providing the service for and then figure out for their particular circumstance.

  • What is the best way to provide the service?

  • So again, as I started going forward, I realized trying to teach you folks a PHP.

  • My admin added too many steps it added too much complication.

  • I just realized too many people would most likely drop out simply because it could get PHP Miami and work.

  • And then that's not good for anybody.

  • So by using this task cell, this is simple.

  • It's easy if you understand how to install the new bond to operating system onto a virtual machine, I'll show you how to use test cell, and you'll literally have my sequel up and running in a couple of minutes.

  • So with that, let's get to the class.

  • So for this particular lab, I'm going to be using virtual box to create an instance of a bun to desktop 18.4 When that is up and running, we will then use Task Cell to be oven installed lamp Lennox a Paki, my sequel, PHP.

  • And then after that is done, we will simply go into my sequel server just to kind of show you that it exists.

  • Show you what?

  • That in effect, it does function.

  • And then again, in the future we will do more classes teaching you how to actually use my sequel.

  • So with what I'm showing you today, you can spend this up with a virtual machine.

  • If you have a physical, if you have a physical server, you could do exactly what I'm doing here.

  • One of the reasons that I decided to create the lab environment this way, using the gooey interface basically the desktop of gooey so on and so forth is.

  • So when we go into the future and we start using a little bit of PHP coding, that type of thing, we can run it on the server itself.

  • So basically, uh, you bunch of desktop has fire Fox so we can open a Web browser in, basically and fire Fox in the server and be able to connect to any like PHP Web pages that were creating and therefore we don't have to worry about network settings.

  • We don't have to worry about firewall issues.

  • We don't have any have to worry about any of that kind of stuff.

  • Basically, we can have this one machine we can run my sequel on his machine.

  • We can create PHP code to be a bit connect to the mice equal on the machine.

  • We can, in view of the results of the PHP code on the machine and again we get to strip out any possible issues with networking problems, firewall problems, security problems, any of that kind of stuff.

  • We have one self contained box.

  • So what I'm showing you today again.

  • You need to be doing this on a virtual machine.

  • I'm using a Mac book pro with work toolbox on it.

  • Or you can have a physical physical box again installed U Bahn to desktop on that and then run task cell, and you will be You will have your lab environment so that let's go over the computer and we'll show you how this works.

  • So here we are, my Mac book pro and again I've got a virtual box open.

  • So the instance we're going to be using today is a soup onto desktop again 18.4 And I've created a version specifically for this.

  • My sequel Class.

  • One of the things that will say if you're doing these kind of classes, you're doing these lab environments.

  • What I would say is trying to create one that, like a default version of whatever operating system that you're dealing with and then when you do different projects when you do different classes, you can go, and you can clone that version.

  • So you can basically copy that version so that you can then go play with the clone.

  • If you trash the clone, then all you have to do is you just simply then remove.

  • You can then delete the clone, create a new clone and go from there.

  • So again, installing an operating system takes a little bit of time, you know, probably insulting operates.

  • System takes 10 or 15 minutes, especially doing the updates and all that type of thing.

  • So if you could just create one default like factory setting version on, then simply when you want to do new new labs, new projects, you clone it, I would argue that's the best way to go.

  • Now again, since this is your bun to a desktop.

  • One of the big things.

  • When you create this particular instances, make sure you give it at least four gigs of Ram s O.

  • If you have the you bunt to server version, you can have 505 12 ram or maybe one gig ram.

  • But remember, if you're easy to Gu ae version, this is a really graphic user environment.

  • So you should give it for gigs of Ram.

  • With that, all we have to dio is double click on Open it up and we're now going to log into are about to box.

  • So here we are.

  • We have our nice little bone to desktop up and running.

  • The first thing that we're going to dio to make sure everything is up today is you go appear to this little search bar and you could do up date, and then you go here to software update, you click on the software update just to make sure everything is updated.

  • So you don't run into any kind of weird problem right again.

  • Especially when we're gonna be dealing with server environments in that type of thing, it's a good idea to update.

  • Thanks first, so this particular box is already updated full.

  • So we're just gonna hit, Okay.

  • They were going to go down here again to this weird little one of those.

  • The show application thing.

  • We're going to go, sir, if you want to Simply going to type in terminal.

  • So we're going to use the terminal in order to do tasks.

  • Ellen, arrest eso now.

  • We actually need to install tax task sells task cell is an app like other absolute pseudo afterlife and get install task.

  • So then we're going to hit Enter.

  • It's gonna askyou password for Bob.

  • 123456 Because again, I'm I'm really serious about security.

  • Yes, doesn't want.

  • And now this is going to simply install this This application for us called Task Cell so that has now been installed hit clear.

  • Then we could do sudo.

  • And then from here on you two a pseudo and then task.

  • So if you're trying to remember this all it is is think about it is Tasked Select.

  • Basically, we're selecting what kind of server we want to create and then we hit enter and then this this little little thing pulp comes up So here again you can see there's lots of different types of servers that you can create really rather easily a d.

  • N s server you've got, you know, the lamp server that we're gonna be doing lube on two things and mail server, print server, samba file server, the tests l was actually a pretty easy, pretty cool little piece of software on is an easy way to be able to spend up servers again.

  • Some people argue about whether or not this is the best way to do it.

  • But what I would argue is for a lab environment where you just need a server pretty quickly in order to be a mess around with things is a good way to go.

  • Eso here, what you do is you hit the space bar so you select what you want and hit the space bar.

  • So you hit the space bar and then you have a tab for OK and then you hit okay, and now it's going to go through when it's going to install and retrieve all of our packages.

  • For us, which is pretty simple.

  • Quick process again as long as you have a computer that's, you know relatively recently.

  • No, nothing here is too complicated or too hard, so it's going through or up to about 91% here.

  • Configure a pattern.

  • You see, my sequel was doing PHP before, right?

  • So is installing, and all of these different service is for you so that you don't have to individually install them so that that's what makes it such a such a nice thing it makes it so easy for deploying a lamp server so again is doing the mod files to know that.

  • And so now, now we're back.

  • Right?

  • So the cool part here, Right?

  • So we go to fire fox versus a nuisance of the lamp service or a lamp server is a web server s o.

  • We simply open up fire Fox.

  • And just to make sure that the lamp servers actually installed, we're going to go to 1 27.0 point 0.1.

  • So what this is called is this little loop back address?

  • So this is the I.

  • P.

  • Address of your computer.

  • So whether you're on a Windows computer, whether you're on Lennox and cuter when you're on a mat computer, the loop back address basically loops you back into your own computer s.

  • So if you're with a web browser, what this will do is Luke you back into the Web server that should be running on your particular computer.

  • So we're going to enter and there There we go.

  • We got the Apache to who bought to default pay.

  • This is the Defoe welcome page used to test the correct operation of a path you to server after installation on you bunk.

  • Two systems.

  • So, basically, if you get this page a path, you too is working or it's working good enough.

  • It's working good enough to give you this big.

  • If you don't get this page, then you've got other problems.

  • Good.

  • Good.

  • Go to Google to figure that out.

  • So you just want to make sure that this is up there.

  • So this means you're basically your Webster was actually working.

  • Okay, so now we're going to log into my sequel using pseudo my sequel.

  • Maybe.

  • Look into this.

  • If you know anything about my sequel, you might be thinking.

  • Well, wait a minute here.

  • Wait a minute.

  • Aren't I supposed to log into my sequel using my sequel Space hyphen?

  • You space the user name Space hyphen P.

  • Isn't that the proper way to log into my sequel?

  • Well, the thing is, with a using task, sell this particular way in order to install your lamp server.

  • It does not create an additional user account for you.

  • Basically, you only have the route user when you install my sequel this way.

  • And so, in order to be able to log in.

  • Initially, you have to use Pseudo my sequel.

  • So in the future, I will show you how to create user accounts for my sequel.

  • And then you will be able to log in using those user accounts.

  • But now, initially, you will be using pseudo my sequel To be able to log in, Gonna be a log in.

  • And look at that.

  • You get a blinking cursor.

  • Yeah.

  • This is why so many people get frustrated with computers and then they give up again.

  • They do not fail.

  • They give up because they just get blinking.

  • Cursor is and they don't know what the hell to do with the blinking cursors.

  • But if you know the commands to use, you'll be fine, eh?

  • So what we're going to do now is we're going to do show data basis.

  • Um, make sure I don't miss type that peace is right.

  • And then at the end of this, we're going to do the semicolon Sochaux databases.

  • We'll show the databases within this particular my sequel server eso.

  • Since this is the initial installation we just installed, it will simply have the default databases.

  • But if this was a production server.

  • You would see all of the databases that were on there.

  • So let's say you had multiple WordPress websites.

  • When we hit Enter here.

  • It would show you all the databases for those different wordpress websites.

  • So we hit inner.

  • And so it shows.

  • Is that that basis?

  • So we have an information scheme of my sequel a performance chema and assist databases.

  • So these air that the different databases no one reported things.

  • When you're in the mice, equal world is you do need that.

  • Semi colon, you do need that Semi colon.

  • If you don't put in the semi colon, it will not know to run the command which can be a royal pain in the butt.

  • Right.

  • So if I d'oh show databases no semicolon and hit enter and it inner and keep hitting at her, I have.

  • Now what do I D'oh, Mom!

  • And what do I do?

  • It's in my colon and then hit enter and then that actually runs the command.

  • So again, this is one of the reasons that things like this can be incredibly frustrating is you put in what you think is the right command.

  • But if you forget that send Michael and you might get lost.

  • So if you ever if you were ever run into one of those positions where all you see is these weird little one of his hero thing is just hit the semi colon.

  • Even even if the command fails, at least a command will fail out, and then you can get back and try to type in the proper command.

  • S O n that what we're going to do is we're actually going to go in to my sequel databases.

  • So this is my secret database, so it d'oh use my sequel.

  • So now it's dead.

  • The database has changed, and we're now actually, in the my sequel database itself of them.

  • From here, we can do show tables.

  • So you wanna talk about the schema?

  • A database is the highest level, the highest level the hierarchy.

  • Then you have tables under that, Then we do semi colon can't forget that.

  • Then we hit enter and we see all these different tables within my sequel database.

  • One of the ones that will be interested here is actually useful is the user table.

  • So these are all the different user accounts within this particular database.

  • And so what we can do is a command called described the E S C.

  • And then we do user and then we do semi colon we hit enter and this gives us the different basically the different columns.

  • Within this particular table S o.

  • You have a host column with a data type of char up to 60 a column of user began characters up to 32.

  • You have a whole bunch of, you know, different privileges.

  • Yes or no configurations here.

  • SSL cipher, those air blob blob data types like we talked about before.

  • Max questions.

  • Max updates Max connections, these air integers then we have Ah, my sequel.

  • Native password Authentication String.

  • It's text.

  • We have a password.

  • Last change has a time stamp data type on.

  • So we basically these are all the different columns.

  • These are all the different fields within the user table.

  • Now, if we actually want to take that, take a look and see what users are in the user table.

  • So, basically, this is what users are in this particular my sequel database server.

  • You do something called Select User.

  • So we're selecting the field user from the table user, right?

  • So this is the user table.

  • And so basically what we want is all we want is the user names from the user table.

  • Then we're going to hiss semi colon, and then we're going to hit in our and now we can see the user's for this particular my sequel.

  • Database server.

  • Wait, Debbie, Debbie insists, mate.

  • Even my secret out sesh we have my secret assists, and we have a root.

  • So the rude user is the actual user account that we're using right now.

  • So if we create users and the future Bomb and Tim and Sue when all those different users, those users will pop up here now one of problems and one of the reasons why you need to know how to be able to write sequel statements to actually be able to give you the proper information is with this what I did here.

  • So this was sequel statements.

  • Basically, what it does is select from the user column, basically selected the users from the user table, right?

  • So something to realize again, what gets people really confused is if you do select and then all so a lot of times you'll see sequel statements where it says select also basically select all the columns and a particular table print out all the information table.

  • But if you do that for, like, the user table, what you're gonna get is a lot of God.

  • So So, yeah, I have ah, have fun with this.

  • And this is why again, it's very important.

  • Understand how secret works Because the difference between something useful as in you can see all the user names in in this particular database server versus gobbledygook is basically whether or not you can write a proper state.

  • So again, I say so if you just sit so lacked user from user.

  • Now you get something that is actually pretty pretty useful there.

  • And so that just kind of shows you that it's my sequel server is actually run.

  • It is actually operational.

  • You can go in there, you can play around a little bit.

  • Don't worry, if you do not understand these particular commands.

  • Oh, I am going to show you all of this in the future classes, and by the end of the series, you will be sick of all of it.

  • Now again, the important thing the important question.

  • Okay, You know, how do you know how long?

  • Get now, rights.

  • Okay, with a fresh installation, you do, Sue, do my sequel.

  • So that logs U n.

  • Okay, uh, do you know how to get out?

  • Do you know how to get out of the my sequel problem?

  • If your answer is exit, you're correct.

  • There you go.

  • So again, what next world In the computer world, you do not know how frustrating it can be.

  • Gettinto A problem that literally have no idea how the hell to get out of it.

  • So with my sequel, Exit exit is the answer.

  • So you have my sequel server.

  • You have a full lamp stack running.

  • Isn't that cool and exciting?

  • So again, we're using the bun to desktop version.

  • So this is a graphical user interface version of a bun, too.

  • The reason that we're doing this is so that we have the local web browser so that we can use that loop back address 1 27.0 dot zero.

  • Not one to be able to be able to read websites being re PHP code directly from the computer that we're working on and the reason that we're doing that is so we don't have to worry about network configurations and firewalls or any any of that kind of mess again, we're using Task Cell here.

  • A lot of people will argue about whether or not you should use Task Cell again.

  • At the end of the day, I don't care for used thyself.

  • You want to install Apache and my sequel in PHP and basically the modules to make all of those to its function together properly.

  • You can go ahead and do that, and you'll end up basically with the same functional thing that we have here.

  • It'll just take a little bit more effort and one of my concerns that you might run into some problems again.

  • Task Cell installs Apache in my sequel PHP and the modules altogether in something functional, whereas if you do it yourself and you forget a molecule, if you forget a configuration, then all of a sudden you're saying they're trying to troubleshoot those problems rather than actually trying to be able to learn.

  • But I'm trying to teach you s so that's why I would recommend task.

  • They'll get in a real production environment.

  • You May, you may question may decide to to go a different route there again, at the end of the day to I was going to do the rest of the Siri's using something called PHP.

  • My admin.

  • PHP.

  • Miami is a very useful tool again.

  • I still use it on my Web production.

  • Webster was my Web servers that actually run in use PHP at Miami just fine, but apparently again, for some reason, the version of PHP, my admin that's in the U Bahn to repositories does not play Lie slave with 18.4 And so, in order to make that work basically duct tape that together, it could be a bit of a pain to the reason I decided not to use PHP.

  • My admin for this particular Siri's simply I don't want to get in that whole troubleshooting process.

  • I don't want to lose people because you start have problems installing pH.

  • Be my admin so you could never get to the whole my sequel component, right?

  • And again, that's something that's very important.

  • Think about when you're learning or for anybody out there trying to teak technical topics.

  • So many times people try to teach so many things at one time that the student gets lost because they don't have a new student.

  • Doesn't know the difference between my sequel and Apache or PHP.

  • Deny and I file.

  • All right, you start talking about the PHP deny and I file right after his talk to start talking about my sequel statements, and they're gonna think PHP dot and I files of my sequel statements.

  • Have anything in the world to do with, you know the psb dot on I file.

  • It's a real P H B.

  • A Paki is for your Apache, my sequel so you might see what these air different things, but one of the problems that people run into as they try to learn so many things at one time.

  • And then they get confused about what what relates to what is a virtual host again, You start talking about unpacking and virtual hosts, and they start thinking that has only with my Sequels like No, no, let's just let's just let let's just focus in on my sequel Learn My Seat will learn sequel statements, and then once you learn my sequel, then we can start in with a PHP then we can start learning with dealing with Apache.

  • And then once you understand all that, then we came to go to more advanced configurations that you would actually put out in a production environment.

  • And then once, once you understand that, then we can start talking about security and locking everything down.

  • The problem is, a lot of times people start worrying about security before even know how to install anything, and it turns into a colossal mess.

  • So anyways, that's basically all there is to create this particular lap again.

  • Want to desktop pseudo at hyphen get installed Task cell Pseudo Task Cell Select the My sequel Database Server and solid their pseudo My sequel that drops you in and then you start using sequel commands.

  • If you don't remember this evil commands, just remember Exit Exit.

  • Remember semicolon?

  • A semi colon actually sins the sequel statements.

  • So basically type something in that keep hitting and her just had a semi colon at some point that will actually run it, and then you get totally confused.

  • It just frustrated Exit e x I t.

  • We'll get you out of there.

  • So, as always, I enjoy doing this class and look forward to the next one.

  • Apparently, the type of content you just saw is not what Susan W.

  • Wants for the future of YouTube.

  • This means that recommendations by YouTube to this channel have dropped massively, and views are becoming a comically small I hate to ask.

  • I used to say I would never ask, but if you could subscribe like common and most importantly, share the videos that you appreciate, that may help slow the death of this channel.

  • Do you remember that if anything at all happens to this channel, you can go to Eli, the computer guy dot com, to view the content and access information not available on YouTube.

creating these classes requires equipment and service.

字幕と単語

ワンタップで英和辞典検索 単語をクリックすると、意味が表示されます

B1 中級

MySQL - MySQL Labs 用 LAMP サーバのインストール (tasksel) (MySQL - Install LAMP Server for MySQL Labs (tasksel))

  • 1 0
    林宜悉 に公開 2021 年 01 月 14 日
動画の中の単語