/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

1 vote208 views1 answer
Remove index.lock git
Shell/Bash
0 vote199 views2 answers
Failed to start openbsd secure shell server
Shell/Bash
1 vote188 views1 answer
Youtube to mp4 linux
Shell/Bash
1 vote188 views1 answer
Compile h5py
Shell/Bash
0 vote217 views1 answer
Endpoint Security VPN build 986000724 is already installed on this computer.
Shell/Bash
0 vote194 views1 answer
Write-only cloudtrail event filter aws cli
Shell/Bash
0 vote182 views1 answer
Run cron once a week
Shell/Bash
2 votes192 views1 answer
Apache2 change directory root
Shell/Bash
5 votes193 views4 answers
How to remove git history for a file
Shell/Bash
0 vote183 views1 answer
Unsupported file ./google-chrome-stable_current_amd64.deb kali
Shell/Bash