Setting up and Securing mySQL & PHP
Duration: 50:44
Created with
Ben Fhala
Ben Fhala is the creative force and founder behind 02geek, a pioneering platform dedicated to making web development accessible to everyone. With over 18 years of experience in the industry, Ben has a deep passion for teaching and a knack for breaking down complex concepts into easy-to-understand lessons.
Setting up and Securing mySQL & PHP Overview
What you'll learn
Over the last few courses we built, secured and setup your http server(apache). In the following last course we will finish up our LAMP server as we focus on the MP part - mySQL and PHP. Over the next few lectures we will install mySQL and PHP and then secure our installations.
Intro
Setting up expectations for our mySQL and PHP setup course
00:42
Installing and Starting up mySQL
n 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.
04:28
Securing mySQL
mySQL comes with a wizard that helps you get rid of security threats to your installation.
06:52
Installing PHP
At this stage all that is left is for us to configure PHP. The process is very similar to the way we install mySQL. We will use yum to install php.
03:17
Taking our new PHP server for a test run
Now that we added PHP to our server it's time for us to test out and validate that everything is working. In the end of this lesson we will have a running php page on our server.
05:40
Validating that our servers will restart every time our server reboots.
Validating that our servers will restart every time our server reboots. We will add httpd and mysqld to our chkconfig so that both will restart any time our server reboots.
01:59
Shorthand script and why it is turned off by default.
Why shorthand script is turned off by default and how to turn it on.
05:52
Securing your PHP installation
We won't talk about every single security option in PHP but we will talk about the most critical ones you want to be familiar with and how you can configure and change them.
06:44
Setting your php ini file for production
Setting your php ini file for production is simple. the first step is we want to locate one that is already configured we will find it in the php project github page. By the end of this lesson your ph
04:38
Why is our screen blank?
Do you know why in our last lesson our screen was blank and we didn't see any PHP script? click play to find out.
01:00
Using the PHP ini_set function
We are almost done exploring the basics of our php settings. There will be cases you will want to change the configurations on the fly. To do that we will use the ini_set function as an override to ou
03:15
Configuring PHP flags in HTTPD
In this session you will learn how to create and set an .htaccess that will enable us to set php settings for specific folders.
05:47
Outro
Outro
00:31