This is a tutorial on how to install MySQL 5.7 on macOS since the default version of MySQL (at the time of writing) is 8.0. Some software like Sequel Pro don’t yet support the changes made in the newer version of MySQL.

Update: Check out Sequel Ace, the fork of Sequel Pro.

First off, if you don’t have Homebrew installed, install it with:

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Note: If you previously installed MySQL 8.0 but are downgrading, let’s uninstall everything first. This will completely remove any MySQL configurations and data that you might have.

brew uninstall mysql
brew uninstall mysql@5.7
rm…


To start off, you can check which version of git you’re using by typing this in your terminal:

git --version

If you use bash (the default shell) edit ~/.bash_profile or if you’ve installed another shell, edit the configuration file for your specific shell. (Ex. For zsh, edit ~/.zshrc.)

In your shell configuration file append the following line:

export PATH=/usr/local/bin:$PATH

Restart your terminal and install git via homebrew (a package manager for mac):

brew install git

You’re done! Try git --version again to see your new git version.

If you ever want to upgrade git in the future, run:

brew upgrade git

Note: If you don’t have homebrew installed, you can install it with this:

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"


1/14/17 — Updated for MongoDB 3.4
6/17/18 - Updated for MongoDB 3.6, Node 8, fixed URLs

TLDR Script

For this tutorial, I’ll be covering how to setup Parse Server and Parse Dashboard so that they run on the same server and port and use SSL encryption.

Parse is a Node.js MBaaS (Mobile Backend-as-a-Service) that runs on the Express Web Framework. Parse has 9 software development kits for just about anything your app will run on. When Parse was first released it was a hosted service with plans for requests over time. After Facebook purchased Parse for $85 million in 2013…


Swapfiles are essentially space on your hard drive that’s used as a virtual extension of your computers physical memory (RAM). Your computer “swaps” physical memory and virtual memory so that it doesn’t overload the physical memory. You typically don’t want to have swapfiles on solid state drives or on virtual private servers. Solid state drives will wear out quicker as they have a finite amount of reads and writes and on virtual private servers, it would probably be more optimal to just upgrade the RAM.

Nonetheless, heres the steps to creating a swapfile:

  1. Start by creating the swapfile. In the…

Normally to login to a server you use the ssh username@hostname command. Here’s a quick tutorial on how to setup a SSH config file so that you can type something like ssh host and connect to your server.

Create the Config File

On your local macOS or Linux computer, make sure you have a SSH key installed. If you don’t, check this out. Go ahead and navigate to the .ssh folder and start editing a file called config.

cd ~/.ssh
sudo nano config

Here’s an example of a server connection that goes in the config file.

Host server
HostName mywebsite.com…


If you’ve ever used SSH to remote into a server, you’ve had to type your password a few times. Setting up a SSH key creates a trust between your local computer and your server, allowing you to login without having to type your password. Below are step-by-step guides for creating a SSH key on Windows and macOS/Linux.

Generate Private and Public Keys

Perform the following steps on your local machine.

Windows

Start off by downloading PuTTy and PuTTYgen.

After opening PuTTYgen, towards the bottom of the window under “Type of key to generate” make sure that “SSH-2 RSA” is selected. Click the generate button.

In order…

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store