Quyen Nguyen decodedmrq

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.

	--Initialise
	SimpleCSV = {}
	SimpleCSV.__index = SimpleCSV

	--Create new object
	function SimpleCSV.new()
	self = setmetatable({},SimpleCSV)
	self.csv_table = {}
	return self
	end

	sudo add-apt-repository ppa:ondrej/php
	sudo apt-get update
	sudo apt-get install php7.1
	sudo apt-get install php7.1-cli php7.1-common php7.1-json php7.1-opcache php7.1-mysql php7.1-mbstring php7.1-mcrypt php7.1-zip php7.1-fpm php7.1-intl php7.1-simplexml
	sudo a2dismod php7.2
	sudo a2enmod php7.1
	sudo service apache2 restart
	sudo update-alternatives --set php /usr/bin/php7.1
	sudo update-alternatives --set phar /usr/bin/phar7.1
	sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.1

	$ cd ~
	$ sudo curl -sS https://getcomposer.org/installer \| sudo php
	$ sudo mv composer.phar /usr/local/bin/composer
	$ sudo ln -s /usr/local/bin/composer /usr/bin/composer

	then you can run
	$ sudo composer install

	Regex for matching ALL Japanese common & uncommon Kanji (4e00 – 9fcf) ~ The Big Kahuna!
	([一-龯])

	Regex for matching Hirgana or Katakana
	([ぁ-んァ-ン])

	Regex for matching Non-Hirgana or Non-Katakana
	([^ぁ-んァ-ン])

	Regex for matching Hirgana or Katakana or basic punctuation (、。’)