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

create-mysql.bash

#!/bin/bash
# The script will fail at the first error encountered
set -e

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

echo "MySQL user created."
echo "Username:   $1"
echo "Password:   $PASS"

Please can this also be used to create tables for database and import csv

Please can this also be used to create tables for database and import csv

You should be able to do that. Did you try it out yet?