Quin452

omeinusch / create-mysql.bash

Created August 31, 2013 11:50

Simple bash script to create mysql db, user with generated password

	#!/bin/bash
	PASS=`pwgen -s 40 1`

	mysql -uroot <<MYSQL_SCRIPT
	CREATE DATABASE $1;
	CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';
	GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
	FLUSH PRIVILEGES;
	MYSQL_SCRIPT