/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

0 vote255 views3 answers
Git log for specific file
Shell/Bash
0 vote204 views1 answer
%2F apache rewrite
Shell/Bash
0 vote205 views1 answer
Npx hint shell: /bin/bash -e {0} env: FORCE_COLOR: 1 Cannot destructure property 'trackException' of 'utils_1.appInsights' as it is undefined. Error: Process completed with exit code 1.
Shell/Bash
21 votes176 views3 answers
Save and quit keys vim
Shell/Bash
0 vote236 views1 answer
Ubuntu history to file without line number
Shell/Bash
2 votes175 views2 answers
Command to delete all files in a directory
Shell/Bash
0 vote205 views1 answer
Sftp remote directory
Shell/Bash
69 votes235 views6 answers
Ubuntu kill running port
Shell/Bash
0 vote209 views1 answer
Volume buttons not working ubuntu 18.04
Shell/Bash
3 votes218 views1 answer
Zsh: command not found: rvm on terminal load
Shell/Bash