$resourcegroup="wordpressappservice"
$location="southeastasia"
az group create -l $location -n $resourcegroup

$planname="wordpressappservice"
az appservice plan create -n $planname -g $resourceGroup `
-l $location --is-linux --sku S1

$mysqlservername="mysql-wpasd123"
$adminuser="wpadmin"
$adminpassword="Maruti@123"
az mysql server create -g $resourcegroup -n $mysqlservername `
 --admin-user $adminuser --admin-password $adminpassword `
 -l $location `
 --ssl-enforcement Disabled `
 --sku-name GP_Gen5_2 --version 5.7

az mysql server firewall-rule create -g $resourcegroup `
--server $mysqlservername --name AllowAppService `
--start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0

$appname="wordpress-wpasd123"
$dockerrepo="wordpress"
az webapp create -n $appname -g $resourcegroup --plan $planname -i $dockerrepo

$wordpressdbhost=(az mysql server show -g $resourcegroup -n $mysqlservername --query "fullyQualifiedDomainName" -o tsv)
$wordpressdbhost

az webapp config appsettings set `
-n $appname -g $resourcegroup --settings `
WORDPRESS_DB_HOST=$wordpressdbhost `
WORDPRESS_DB_USER="$adminuser@$mysqlservername" `
WORDPRESS_DB_PASSWORD="$adminpassword"