mysql bash 脚本,在bash脚本中创建mysql数据库和用户

This seems like it should be simple and I swear this code has worked for months but it's not working now. I'm sure I'm just overly tired but I would appreciate a knowing nudge.

# create random password

PASSWDDB="$(openssl rand -base64 12)"

# replace "-" with "_" for database username

MAINDB=${USER_NAME//[^a-zA-Z0-9]/_}

# create database and user

mysql -e "CREATE DATABASE $MAINDB"

mysql -e "GRANT ALL PRIVILEGES ON $MAINDB.* TO $MAINDB@localhost IDENTIFIED BY '$PASSWDDB!'"

MAINDB is supplied previously in the script. What I end up with is a database, a user, and proper permissions and the user has a password - it's just not the password defined in $PASSWORDDB.

MariaDB 10.0.22

Ubuntu 14.04

解决方案

In your case you can use this:

# 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