Create a database and an user associated with it

create-db.sh

mysql -uroot -p -e "CREATE DATABASE mydb;CREATE USER myuser@'%' IDENTIFIED BY 'secret';GRANT ALL PRIVILEGES ON mydb.* TO myuser@'%';"

create-db.sql

# run these if you got kicked by mysql password policy
/* 
set global validate_password.policy = LOW;
set global validate_password.length = 2;
set global validate_password.mixed_case_count = 0;
set global validate_password.number_count = 0;
set global validate_password.special_char_count = 0;
*/
CREATE DATABASE mydb;
CREATE USER myuser@'%' IDENTIFIED BY 'secret';
GRANT ALL PRIVILEGES ON mydb.* TO myuser@'%';