etc/mysql/bin/createdb

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