mysql-setup.sh

#!/usr/bin/env bash

source ./config.defaults.sh
if [ -f "./config.sh" ]; then
  source ./config.sh
else
  echo "You have no config.sh. Copy config.defaults.sh to config.sh, change the passwords and try again." && exit 1;
fi

USER_EXISTS=$(docker exec $T_MYSQL_CONTAINER_NAME mysql -u root -p"$T_MYSQL_PASSWORD" -sse "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = '$T_MYSQL_USER')")

if [ "$USER_EXISTS" = 1 ]; then
  echo "MySQL user is already set up."
  USER_NEEDS_PLUGIN_UPDATE=$(docker exec $T_MYSQL_CONTAINER_NAME mysql -u root -p"$T_MYSQL_PASSWORD" -sse "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = '$T_MYSQL_USER' AND plugin = 'mysql_native_password')")
  if [ "$USER_NEEDS_PLUGIN_UPDATE" = 1 ]; then
    # Post MySQL 8.0.27, and 8.4+ mysql_native_password is deprecated. Alter the user plugin to caching_sha2_password
    echo "Updating user plugin..."
    CMD="docker exec $T_MYSQL_CONTAINER_NAME mysql -u root -p'$T_MYSQL_PASSWORD' -e \"ALTER USER '$T_MYSQL_USER'@'%' IDENTIFIED WITH caching_sha2_password BY '$T_MYSQL_PASSWORD';\""
    eval ${CMD}
  fi
else
  echo "Setting up mysql user..."
  CMD="docker exec $T_MYSQL_CONTAINER_NAME mysql -u root -p'$T_MYSQL_PASSWORD' -e \"CREATE USER '$T_MYSQL_USER'@'%' IDENTIFIED WITH caching_sha2_password BY '$T_MYSQL_PASSWORD';\""
  eval ${CMD}
  CMD="docker exec $T_MYSQL_CONTAINER_NAME mysql -u root -p'$T_MYSQL_PASSWORD' -e \"GRANT ALL PRIVILEGES ON \"*.*\" TO '$T_MYSQL_USER'@'%' WITH GRANT OPTION;\""
  eval ${CMD}
fi