Time
7 hours 36 minutes
Difficulty
Beginner
CEU/CPE
3

Video Transcription

00:00
I welcome back to muzzle one course introduction. This is less than three environment set up, and we are moving into Lesson 3.4, my sequel installation under a Blue to Lennox and the previous two lessons we install. Both my sequel and D B were under the Windows insulation and this lesson. We are going to install the my sequel database Engine Under a Blue to Lennox.
00:19
Now, with the escalation of my sequel under a boon to You might be tempted to simply go to the terminal
00:26
and run the APP. Get install my sequel server under a installation of a boot to, however, you don't want to just go off and do that because you will actually install my sequel server version 5.6 I believe, and the problem there is that is
00:42
kind of an old version, and there were. There will be features
00:46
missing from that when compared to version eighth, and one easy feature that will be missing is the ability to use table expressions.
00:56
That version of my sequel will not allow you to use table expressions, however, inversion eight. You will have the use of table expressions, so you'll have more tools and capabilities. With that, it's also more secure. So it's a good idea to go this extra route and get my sequel eight installed on your Abou to Lennox.
01:15
With that said, What you want to do is go to the dev dot my civil dot com domain. I will provide a link
01:21
in the study guide materials, so feel free to check that out for the exact link, and you will want to download the package file that my sequel provides. I've already done that
01:33
so similar to Windows. I need to go to my download folder
01:37
and this is download of that package. I will go ahead and open in Terminal, which opens a terminal to this location,
01:47
and I'm going to switch to the suitable user.
01:52
I will type in my password.
01:53
I am now the suitable user, and I'm going to run the package command that I need to run. So that is
02:00
B B D P
02:02
kg
02:04
space Dash I
02:07
and then my eye sequel tab to complete. There's only one file in that directory, so Tab will automatically open that file name to the command
02:16
will hit enter to run it
02:20
Once you arrive at this screen, you're configuring what version of my sequel that you want to use. So right now I have my sequel, Dash eight
02:29
Selected. That's what I want. But if you If you have, for example, five selected, you can switch by highlighting that first option and hitting enter
02:38
and moving down to the version of my sequel you want to use, which is eight in our case and hitting enter.
02:44
Once you have that current selection set to my sequel AIDS, you could click okay
02:50
and that will apply that setting
02:53
and then the command you need to run
02:54
is apt. Get update
02:58
that will make sure that the package repositories are correctly updated to install the new my sequel version. If you don't run up to get update, you risk possibly downloading and installing the older version of my sequel.
03:13
Okay, once that's finished running.
03:15
Now we just need to run the APP, get install
03:19
my sequel server
03:23
and you'll give prompted to go in and use that space to install the application. Yes,
03:30
and it will run through the installation process.
03:34
Go ahead, and once you arrive at the password screen, go ahead and enter a password. You feel confident about remembering
03:42
and then reactor to confirm,
03:45
then hit. Okay.
03:49
And again here, just like we did in Windows. We're gonna use the legacy authentication methods so that we do not have to Ah, worry about setting up SSL certificates.
03:59
That's a little bit more than what we want to worry about when dealing with the development.
04:06
Okay. And then it's gonna go head and configure
04:10
the my sequel server based on our
04:13
password and selection.
04:15
Okay, we're at the end. That installation just finished for the next two man, we want to run. Is that my sequel? Secure Installation Command,
04:23
which is my sequel. Underscore. Secure. Underscore. Installation
04:28
again. We are the route user. We've switched to it. I haven't switched back to the regular user.
04:34
If you are not the route user, you'll have the pen suitable to every command.
04:40
So I will enter the password for the route user I established during the installation.
04:45
We're not going to use the validate password functionality for development.
04:50
We're not going to change the route Password for development.
04:54
We will go ahead and remove anonymous users. We don't need them.
05:00
We will not disallow root log in remotely.
05:05
Well, go ahead and remove the test database. We don't need it.
05:10
We will go ahead and reload
05:12
privilege tables.
05:15
And we are all done now, just to test that we have my sequel server installed and the version we can go ahead and log into it.
05:23
My sequel
05:24
slash you
05:26
user route and put in that dash p for the password command. You know, the password you entered earlier
05:33
and we are in and you can see that we have the server version of 8.0 point 15. So we successfully installed the most current version of my sequel on a blue to Lennox Hope you were able to follow along. I hope you were able to get this work in. And I look forward to seeing you in the next lesson. Thank you.

Up Next

Introduction to SQL

This introduction SQL training course teaches SQL core concepts that are applied in professional environments. Once completed with the course, students will be able to query and interact with an SQL database, and know how to design database schemas.

Instructed By

Instructor Profile Image
Kitt Parker
Instructor