/Shell/Bash/Create mysql user and database from script

Create mysql user and database from script

# create random password
PASSWDDB="$(openssl rand -base64 12)"

# replace "-" with "_" for database username
MAINDB=${USER_NAME//[^a-zA-Z0-9]/_}

# If /root/.my.cnf exists then it won't ask for root password
if [ -f /root/.my.cnf ]; then

    mysql -e "CREATE DATABASE ${MAINDB} /*\!40100 DEFAULT CHARACTER SET utf8 */;"
    mysql -e "CREATE USER ${MAINDB}@localhost IDENTIFIED BY '${PASSWDDB}';"
    mysql -e "GRANT ALL PRIVILEGES ON ${MAINDB}.* TO '${MAINDB}'@'localhost';"
    mysql -e "FLUSH PRIVILEGES;"

# If /root/.my.cnf doesn't exist then it'll ask for root password   
else
    echo "Please enter root user MySQL password!"
    echo "Note: password will be hidden when typing"
    read -sp rootpasswd
    mysql -uroot -p${rootpasswd} -e "CREATE DATABASE ${MAINDB} /*\!40100 DEFAULT CHARACTER SET utf8 */;"
    mysql -uroot -p${rootpasswd} -e "CREATE USER ${MAINDB}@localhost IDENTIFIED BY '${PASSWDDB}';"
    mysql -uroot -p${rootpasswd} -e "GRANT ALL PRIVILEGES ON ${MAINDB}.* TO '${MAINDB}'@'localhost';"
    mysql -uroot -p${rootpasswd} -e "FLUSH PRIVILEGES;"
fi

Source: stackoverflow.com

Similar codes

41 votes246 views6 answers
Tar gz linux command
Shell/Bash
0 vote245 views1 answer
Mongodb install issues
Shell/Bash
4 votes233 views2 answers
Store printed output in variable bash
Shell/Bash
1 vote240 views1 answer
Rpi install pivpn
Shell/Bash
0 vote236 views1 answer
Linux for loop 1 to 100 odd
Shell/Bash
4 votes231 views3 answers
Ds_store gitignore
Shell/Bash
0 vote257 views1 answer
Heroku pg:pull ----exclude-table-dat
Shell/Bash
0 vote266 views1 answer
Pip install ssh with yes
Shell/Bash
1 vote242 views1 answer
View running jobs linux
Shell/Bash
0 vote232 views1 answer
Flutter upgrade ou are not currently on a release branch. Use git to check out an official branch ('stable', 'beta', 'dev', or 'master') and retry, for example: git checkout stable
Shell/Bash