mroffice

MySQL Commands, Tips and Theory

Commands

mysql -u <user> -p<password> # login, without prompt

Note: Password is in plain text, no space between flag and value

mroffice

Common Apache Commands and Features

Commands

Checks Syntax of Configuration Files

apachectl -t

Lists Loaded modules

mroffice

## User Setup

### Adding a User

Once you've found a suitable server you'll need to login to it and manage it from the command line. Usually you will be given root access (this means a root user exists on the server, with no restrictions) initially and it's up to you to secure the server with best practices. For any public facing server it is recommended that you setup a new user and disable log in using the root user.

$ adduser <example>

mroffice

Terminal Command Cheatsheet

Shortcuts

ctrl + A => Beginning of line
ctrl + E => End of line
ctrl + L => Clears screen
ctrl + U => Clears before cursor
ctrl + H => Backspace

mroffice

Modes

i // => Changes between input mode and normal mode

v // => Changes between visual mode and normal mode

Movement within File

gg // => Takes you to the begginning of the file

mroffice

How to Create a Fresh Magento Install on your Local Development Environment (Mac)

1. Download, install and setup MAMP or MAMP Pro

n.b. For further instructions on how to set-up Mamp Pro like a pro, see this Gist

2. Download the latest version of Magento, and the sample data

3. Expand the Magento tar file into your chosen directory (I use ~/Dev), rename the created magento folder as you wish and enter the directory

mroffice

See Updates for new additional info

What is SUPEE-6788?

SUPEE-6788 is a bundle of patches for Magento. From the Magento Commerce website:

[SUPEE-6788] provides protection against several types of security-related issues, including remote code execution, information leaks and cross-site scripting.

## Why is it more complicated than previous patches?

mroffice

MAMP Pro 3.0 with Clean URLs for Mac Guide

1. Download and install MAMP Pro 3

n.b. You need to download and install both MAMP and MAMP Pro

2. Under General in the preferences click Set default MAMP ports and hit Save

3. Open Terminal and stop Apache:

mroffice

PHP

Debugging

When you want to learn a new framework or programming language, chances are you'll Google something like "how do i run php locally?" or "how do i make a blog with CakePHP?". Funnily enough, Google will provide you with results that tell you just that, but no more.

If you want to really learn and understand web development or the like, you need to actually know what's happening, rather than just knowing which buttons to hit to make magic happen.

mroffice

Git

Setup

List your current config:

git config --list

Set a config option: