Hos Gee hosquiat

hosquiat / createdb

Last active April 28, 2018 00:38

Create and provision a mysql script quickly... Script expects a database name user and password.

	#!/bin/bash

	EXPECTED_ARGS=3
	E_BADARGS=65
	MYSQL=`which mysql`

	Q1="CREATE DATABASE IF NOT EXISTS $1;"
	Q2="GRANT USAGE ON . TO $2@localhost IDENTIFIED BY '$3';"
	Q3="GRANT ALL PRIVILEGES ON $1.* TO $2@localhost;"
	Q4="FLUSH PRIVILEGES;"

hosquiat / wp-perms-reset

Created March 9, 2017 21:43

	#!/bin/bash
	#
	# This script configures WordPress file permissions based on recommendations
	# from http://codex.wordpress.org/Hardening_WordPress#File_permissions
	#
	# Author: Michael Conigliaro
	#
	WP_OWNER=changeme # <-- wordpress owner
	WP_GROUP=changeme # <-- wordpress group
	WP_ROOT=/home/changeme # <-- wordpress root directory