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

create-mysql.bash

#!/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

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

good one, thanks

Thank you.

So helpful. Thank you.

Thanks!
I added just a line to prevent execution if errors are fired.
https://gist.github.com/askz/bee1e31e96e39b653cb77815ae664fa2

Thanks for sharing.
I just developed one myself. Hope you find it helpful:
https://gist.github.com/MagePsycho/823070addf1764c91b86f258767a62d1

I am new to scripting so please bear with me. I have created a script that installs httpd and mariadb but how do I get it so this part continues and creates database, user, etc automatically? my goal is to have the whole process of installing httpd, mariadb, and wordpress on my server automatically. Thanks!