/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 vote108 views1 answer
Ubuntu install ssh-agent
Shell/Bash
4 votes122 views1 answer
Install node on fish shell
Shell/Bash
0 vote113 views3 answers
Brew install memcached
Shell/Bash
2 votes132 views1 answer
Direnv
Shell/Bash
9 votes116 views1 answer
Cmd commands for wifi password
Shell/Bash
0 vote109 views3 answers
At node:internal/main/run_main_module:17:47 { code: 'MODULE_NOT_FOUND', requireStack: []
Shell/Bash
2 votes119 views2 answers
Ignorer des fichiers déjà existant git
Shell/Bash
0 vote119 views1 answer
Install angular 9.1.7
Shell/Bash
2 votes131 views1 answer
Yarn 2 outdated packages
Shell/Bash
0 vote128 views1 answer
Add user to dialout group
Shell/Bash