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

Securing mySQL

Now that we have our mySQL server installed it's time for us to secure it. The good news is that it is really easy to do so. mySQL comes with a wizard that helps you get rid of security threats to your installation. The wizard is located at: /usr/bin/mysql_secure_installation.

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