Hello @Jamie Soon ,
Step by step guide to get MySQL connection details in Azure Web App:
- Go to Azure Portal
Open your Web App in the Azure portal.
- Navigate to Configuration
Under the Settings section, go to Configuration.
Check the Application settings and Connection strings tabs.
- Find the MySQL connection string
Look for a connection string with something like:
Database=jamiesoonwebsite-database;Data Source=mydb.mysql.database.azure.com;User Id=myuser@mydb;Password=yourpassword;
- Database name:
jamiesoonwebsite-database
- Server address:
mydb.mysql.database.azure.com
- Username:
myuser@mydb
- Password: as provided in the string
Make sure you do not use localhost
as the server address. Azure does not run MySQL locally in the Web App, it connects to an external MySQL service (azure database for MySQL).
- Enter these values in the EE Wizard
Use these in the ExpressionEngine wizard:
- Server address: use the
Data Source
value (e.g., mydb.mysql.database.azure.com
)
- Name: use the
Database
value
- Username: use the
User Id
- Password: from the connection string
Common error reasons:
Using localhost
instead of the Azure MySQL server address.
Typo in username or password.
- Database not yet created (ExpressionEngine does not auto create it).
Tip:
If you are using Azure Database for MySQL, make sure:
The firewall rules allow access from Azure services or your Web App.
- SSL settings match what the CMS expects (some CMS setups require SSL to be turned off for testing).Step by step guide to get MySQL connection details in Azure Web App:
- Go to Azure Portal
Open your Web App in the Azure portal.
- Navigate to Configuration
Under the Settings section, go to Configuration.
Check the Application settings and Connection strings tabs.
- Find the MySQL connection string
Look for a connection string with something like:
Database=jamiesoonwebsite-database;Data Source=mydb.mysql.database.azure.com;User Id=myuser@mydb;Password=yourpassword;
- Database name:
jamiesoonwebsite-database
- Server address:
mydb.mysql.database.azure.com
- Username:
myuser@mydb
- Password: as provided in the string Make sure you do not use
localhost
as the server address. Azure does not run MySQL locally in the Web App, it connects to an external MySQL service (azure database for MySQL).
- Enter these values in the EE Wizard
Use these in the ExpressionEngine wizard:
- Server address: use the
Data Source
value (e.g., mydb.mysql.database.azure.com
)
- Name: use the
Database
value
- Username: use the
User Id
- Password: from the connection string Common error reasons: Using
localhost
instead of the Azure MySQL server address. Typo in username or password.
- Database not yet created (ExpressionEngine does not auto create it). Tip: If you are using Azure Database for MySQL, make sure: The firewall rules allow access from Azure services or your Web App.
- SSL settings match what the CMS expects (some CMS setups require SSL to be turned off for testing). Refer this link for Installing ExpressionEngine