02Geek HTML5 and JavaScript, TypeScript, React, Flash, ActionScript online School
Previous VideoNext Video

Installing and Starting up mySQL

We ended our last lesson as we had our linux and your Apache server configure and secure. In this session we will install mySQL using yum. In the process we will talk about dependencies and we will end this lesson by starting up our new mySQL server.

Video Transcript

00:00We last let off, well we last left off, we had a server, we installed HTTPD, we
00:07configured our security settings, HTTPD better known as Apache. It's time for us
00:13to move on to the next step in that lamp configuration where L was for our Linux,
00:17A was for our Apache, and we're time for our oomp. So our oomp lamp lamp. So let's
00:27first start with the M which is MySQL. So to install MySQL, MySQL is
00:33quite simple and the security configurations are also a lot easier to
00:37configure. If you don't know what a MySQL server is, it basically enables you to
00:42store information and the biggest difference between that and a text file
00:47or any other sort of file storage configurations is that my SQL
00:54servers are built for searching, they're built for cataloging, making it much
00:59easier to fetch and retrieve information, especially as your information is growing
01:03and it makes it much easier to make it dynamic as well because most server side
01:07languages have mediators that help you communicate with MySQL. Alright, so
01:14let's get started. Let's see how you install it and the process is similar
01:17to how you installed any other service so far. So we're going to use our
01:21sudo command. I'm logged into our demo account and I'm going to call the yum
01:26command which is our installer and ask it to install and then I'm going to tell it
01:30what do I want to install which is my SQL dash server and the MySQL server
01:36will be all that we need to have my SQL running on our server. It's basically a
01:40server of my SQL. So I'm going to run that and I'm going to click on Enter
01:44and by the way as I'm saying that there's different types of sequels.
01:48SQL is the core language you could say and there's different implementation
01:52where MySQL is the open source version, the one that doesn't cost you a thing
01:57versus other versions that such as Microsoft has and other companies have
02:02that enable you to use other types of SQL servers but for the most part as
02:07we're running on a Linux we want to use the free version softwares such as
02:11MySQL. Alright, so I'm going to type in my password to my user demo so I could
02:16go through the installation process it's going to find the packages that it
02:20needs so you could see for the MySQL server to install it depends on a few
02:25other packages such as the Perl DB and so on and so forth so what we're going
02:30to do is going to approve it we're going to say yes we're going to agree to
02:32install all these different packages that are dependent on the MySQL server
02:37and we're just going to let it go through and install MySQL. Once the
02:42installation process is complete we still have a few more steps left the
02:47first one just as you remembered you if you recall when we created the HCDPD our
02:52server we also said hey we want to restart that service because really what
02:56we're installing is another server instead of a server that stores files
03:01the store server stores SQL it stores information it stores data that is
03:07organized into tables so we want to make sure that we start up that server
03:12we want to start up that server so now that the installation is complete I'm
03:16going to call again the sudo command and this time I'm going to call the
03:19service command and I'm going to call my SQL D and I'm going to ask it to
03:26start and that's the name of our server my my SQL D and I'm going to ask
03:30for it to start once I do that you're going to see that it's going to start
03:34that installation it's going to start that process and it's going to start my
03:39SQL especially because it was the first time we've ever done it and by the way
03:42this process is very um you have a lot of information now but the process is
03:50very similar such as when we did my SQL when we did other services like
03:54HCDPD we could do restart as well restart or we could stop it so restart
04:01would then stop our my SQL and then it would restart it again alright so it's
04:08stopping my SQL it's restarting it again so that is everything that has to do
04:12with the process of installing and making our server our my SQL server run
04:16in the next video we're going to look into the steps involved with securing
04:21my SQL and you'll be surprised to see how simple it is so you're going to see
04:24that in the next video or lesson

Ready to Level Up Your Skills?

Join thousands of learners on 02GEEK and start your journey to becoming a coding expert today!

Enroll Now for Free!