Install Nginx + PHP + MySQL on Mac Os in 2020

This tutorial shows how to install Nginx + PHP + MySQL on Mac OS Catalina. It’s very straightforward process and doesn’t takes you more than 10 to 15 minutes. Install PHP First of all, ensure that brew brew is up-to-date and then install latest php 7.4 version. To locate your ini files type the following…

Read More

MySQL Normalization

Database normalization is a process of organizing fields and tables which reduces dependancy of data and redundancy. There are 6 normal form. In most cases it’s only need 3 normal form to achieve normalization. What normal forms are? 1NF (First Normal Form) Rules Each table cell should contain a single value Each record needs to…

Read More

Installing Nginx + PHP-FPM + MySQL on OS X

Setting up working environment is the first step you need to do. This will be your local web server for programming in OS X with PHP, Nginx and MySQL (also known as LEMP). Let’s make it as ease as possible 😉   What we will do Install xcode (for license) and brew package manager (as…

Read More

Posts about MySQL:

  • how to use queries
  • optimisation of queries
  • data structures
  • and more