stocky-petabyte-29883
08/05/2022, 2:21 PMnew remote.Command("mysql-setup-execute", {
connection,
create: pulumi.interpolate`chmod 777 ./mysql-setup.sh; ./mysql-setup.sh`,
delete: "rm mysql-setup.sh",
environment: {
MASTER_USER: masterUsername,
MASTER_PASSWORD: masterPassword!,
DB_USERNAME: dbUsername,
DB_PASSWORD: dbUserPassword,
DB_NAME: dbName,
DB_HOST: dbHost
}
}, { dependsOn: remoteFile });
Shell script
#!/bin/bash
sudo yum -y install mariadb
mysql -u ${MASTER_USER} -p${MASTER_PASSWORD} -h${DB_HOST}<<MYSQL_SCRIPT
CREATE USER ${DB_USERNAME}@% IDENTIFIED BY '${DB_PASSWORD}';
GRANT ALL PRIVILEGES ON ${DB_NAME}.* TO '${USERNAME}'@'%';
FLUSH PRIVILEGES;
MYSQL_SCRIPT
What am I missing?