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.