#!/bin/sh -eux db="$1" user="$2" sudo -u mysql mysql --batch <<-EOF DROP DATABASE IF EXISTS $db; CREATE DATABASE $db CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL PRIVILEGES ON $base.* TO '$user'@'localhost' IDENTIFIED WITH auth_socket; FLUSH PRIVILEGES; EOF