#!/bin/bash MRP=$MYSQL_ROOT_PASSWORD # Initialize variable db_command_path="" # Check for mariadb command if command -v mariadb &> /dev/null then db_command_path=$(command -v mariadb) elif command -v mysql &> /dev/null then # Check for mysql command db_command_path=$(command -v mysql) else echo "Neither mariadb nor mysql command found." exit 1 fi echo "CREATE USER IF NOT EXISTS 'smartdata_admin' IDENTIFIED BY '$MYSQL_PASSWORD';" | $db_command_path -u root --password=$MRP echo "CREATE USER IF NOT EXISTS 'smartdata' IDENTIFIED BY '$MYSQL_PASSWORD';" | $db_command_path -u root --password=$MRP echo "CREATE USER IF NOT EXISTS 'tutorial' IDENTIFIED BY '$MYSQL_PASSWORD';" | $db_command_path -u root --password=$MRP echo "GRANT ALL PRIVILEGES ON *.* TO 'smartdata_admin';" | $db_command_path -u root --password=$MRP echo "GRANT ALL PRIVILEGES ON *.* TO 'smartdata';" | $db_command_path -u root --password=$MRP echo "GRANT ALL PRIVILEGES ON *.* TO 'tutorial';" | $db_command_path -u root --password=$MRP