Skip to content

Instantly share code, notes, and snippets.

Avatar

Ben Keith benlk

View GitHub Profile
@benfurfie
benfurfie / MySQL_5-7_macOS.md
Created Nov 2, 2018 — forked from operatino/MySQL_5-7_macOS.md
Install MySQL 5.7 on macOS using Homebrew
View MySQL_5-7_macOS.md

This is a fork of original gist https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e, with slight changes on pointing to 5.7 version branch, instead of 8 (latest default of MySQL in Hombrew).

Install MySQL 5.7 on macOS

This procedure explains how to install MySQL using Homebrew on macOS (Sierra 10.12 and up)

Install Homebrew

  • Installing Homebrew is effortless, open Terminal and enter :
    $ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
  • Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.
@tommeagher
tommeagher / #NICAR18 advice
Last active Mar 9, 2018
Note to self for #NICAR16
View #NICAR18 advice
Next year, try to:
* Drink more water.
* Drink less coffee, beer and whiskey.
* Eat a vegetable, it won't kill you.
* Get up and hit the gym in the morning.
* Leave the hotel at least once every day.
* Bring extra charging cords and a powerstrip. Write your name on the supplies you lend out. (@ecarewgrovum)
* Eat meals with parties of 4. It's much easier to get a table in a busy town. For big groups, just get drinks.
* Split into smaller groups, if you take a large party to dinner, and you have to wait forever. (@chrislkeller)
@jchristopher
jchristopher / gist:f8bb12e2d0e60b22676e
Last active Jul 7, 2016
Create SearchWP database tables by hand
View gist:f8bb12e2d0e60b22676e
-- Create syntax for TABLE 'wp_swp_cf'
CREATE TABLE `wp_swp_cf` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`metakey` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`term` int(20) unsigned NOT NULL,
`count` bigint(20) unsigned NOT NULL,
`post_id` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `metakey` (`metakey`),
KEY `term` (`term`),
You can’t perform that action at this time.