25 lines
774 B
Bash
25 lines
774 B
Bash
|
#!/bin/bash
|
||
|
|
|
||
|
|
read -e -p "Enter database name: " -i "maniacontrol_db" DATABASE_NAME
|
||
|
|
read -e -p "Enter user name: " -i "maniacontrol" USER_NAME
|
||
|
|
read -s -p "Enter user password: " USER_PASSWORD
|
||
|
|
echo
|
||
|
|
echo
|
||
|
|
|
||
|
|
# Preparation
|
||
|
|
SQL_FILE_NAME="install_db.sql"
|
||
|
|
rm -f ${SQL_FILE_NAME}
|
||
|
|
|
||
|
|
echo "Creating SQL script ..."
|
||
|
|
echo "CREATE DATABASE ${DATABASE_NAME} DEFAULT CHARACTER SET 'utf8mb4' DEFAULT COLLATE 'utf8mb4_unicode_ci';" >> ${SQL_FILE_NAME}
|
||
|
|
echo "CREATE USER '${USER_NAME}'@'localhost' IDENTIFIED BY '${USER_PASSWORD}';" >> ${SQL_FILE_NAME}
|
||
|
|
echo "GRANT ALL PRIVILEGES ON ${DATABASE_NAME}.* TO '${USER_NAME}'@'localhost';" >> ${SQL_FILE_NAME}
|
||
|
|
|
||
|
|
echo "Executing SQL script as root ..."
|
||
|
|
sudo mysql -u root -p < ${SQL_FILE_NAME}
|
||
|
|
|
||
|
|
echo "Cleaning up ..."
|
||
|
|
rm ${SQL_FILE_NAME}
|
||
|
|
|
||
|
|
echo "Done."
|